{"text_format":"1","workbook":"xlsx","n_sheets":39,"sheets":["Cover Sheet","Level II","WS 2-1","WS 2-2","WS 2-3","WS 2-4a","WS 2-4b","WS 2-5","Level III","WS 3-1","WS 3-2","WS 3-3","WS 3-4","WS 3-5","WS 3-6","WS 3-7","WS 3-8","WS 3-9","WS 3-10","WS 3-11","WS 3-12","WS 3-13","WS 3-14","WS 3-15","WS 3-16","WS 3-17","WS 3-18","WS 3-19","WS 3-20","WS 3-21","Level IV","WS 4-1","WS 4-2","WS 4-3","WS 4-4","WS 4-5","WS 4-6","WS 4-7","WS 4-8"],"not_rendered":{"charts":6,"images":25,"macros":1,"external_links":0,"defined_names":205,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover Sheet","index":0,"n_rows":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,15,1,22],[6,15,7,15],[2,15,5,22],[12,2,12,9],[7,1,8,1],[7,2,8,9],[1,2,1,9],[2,2,2,9],[3,2,4,9],[3,1,4,1],[5,1,6,1],[5,2,6,9],[10,2,10,3],[11,2,11,3],[9,2,9,3]]}
[]
[null,null,"River Stability Field Guide Forms & Worksheets",null,null,null,null,null,null,null,null,null,null,null,null,"Custom Theme Colors"]
[null,"ü","This file contains all the worksheets from the River Stability Field Guide (2nd Edition, 2014).",null,null,null,null,null,null,null,null,null,null,null,null,"A custom color theme was created for this excel file that corresponds to the colors used in the River Stability Field Guide. The first seven colors in the custom pallete are as follows. If you wish to create a custom color theme with the below colors, refer to Microsoft's Excel Help.  Creating a custom color theme is beneficial when copying individual workbooks to new files.  "]
[null,"ü","Some of the worksheets contain checkbox functions; depending on which version of excel you have, the macros need to be enabled and the security settings need to be set to medium."]
[]
[null,"ü","Most worksheets are \"protected\" so you don't accidently delete formulas and text. There is no protection password on the worksheets; you can \"unprotect\" the sheet within \"Permissions\" under the \"File\" tab."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colors (RGB):"]
[null,"ü","Most worksheets contain fields to insert the Stream Name, Location, Observers, Stream Type, Landscape Type, and Date. Enter these fields below to have them automatically inserted in all the worksheets:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R:",231,176,255,255,244,84,229]
[null,null,"Stream:",null,null,null,null,null,"Stream Type:",null,null,null,null,null,null,"G:",246,225,253,244,135,178,255]
[null,null,"Location:",null,null,null,null,null,"Landscape Type*:",null,null,null,null,null,null,"B:",253,250,209,64,79,54,229]
[null,null,"Observers:",null,null,null,null,null,"Date:"]
[null,null,"*For Landscape Type, enter the identifier"]

{"sheet":"Level II","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,2,2,2]]}
[null,"Level II: Morphological Description","River Stability Field Guide Page Number"]
[null,"Forms & Worksheets"]
[]
[]
["1.","Worksheet 2-1.  Sample form to record gage station and field data.","Page 2-12"]
["2.","Worksheet 2-2.  Computations of bankfull mean velocity and bankfull discharge using various methods.","Page 2-49"]
["3.","Worksheet 2-3.  Field form for Level II stream classification.","Page 2-60"]
["4.","Worksheet 2-4a.  Morphologcial relations, including dimensionless ratios fo river reach sites.","Pages 2-62         to 2-63"]
["5.","Worksheet 2-4b.  Morphologcial relations, including dimensionless ratios fo river reach sites.","Pages 2-64         to 2-65"]
["6.","Worksheet 2-5.  Dimensionless ratios of the ten pool types.","Page 2-68"]

{"sheet":"WS 2-1","index":2,"n_rows":60,"n_cols":16,"rows_kept":60,"cut":false,"hidden":false,"merged":[[55,1,55,2],[55,5,55,7],[57,1,57,3],[57,8,57,10],[59,1,59,12],[1,15,7,18],[49,1,49,12],[51,1,51,12],[53,1,53,3],[53,5,53,7],[31,1,31,10],[33,1,33,10],[35,1,35,12],[37,1,37,3],[37,8,37,10],[39,1,39,3],[39,8,39,10],[25,1,25,3],[25,8,25,10],[27,1,27,3],[27,8,27,10],[54,1,54,2],[54,5,54,7],[41,1,41,3],[41,8,41,10],[43,1,43,12],[45,1,45,3],[45,8,45,10],[47,1,47,3],[47,8,47,10],[29,1,29,3],[29,8,29,10],[19,1,19,3],[19,8,19,10],[21,1,21,3],[21,8,21,10],[23,1,23,3],[23,8,23,10],[17,1,17,3],[17,8,17,10],[7,1,7,2],[7,5,7,7],[7,9,7,10],[9,1,9,2],[9,4,9,6],[9,7,9,8],[9,9,9,10],[11,1,11,3],[11,9,11,10],[13,1,13,12],[15,1,15,5],[15,8,15,12],[5,1,5,2],[5,3,5,8],[5,9,5,10],[1,1,1,12],[3,1,3,2],[3,3,3,8],[3,9,3,10],[3,11,3,12]]}
[]
[null,"Summary of USGS Gage Station Data",null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[]
[null,"Station Name:",null,null,null,null,null,null,null,"Station Number:"]
[]
[null,"Station Location:",null,null,null,null,null,null,null,"Period of Record:",null,null,"yrs"]
[]
[null,"Drainage Area (DA):",null,null,"acres",null,null,null,"mi2","D.A. Mean Elevation:",null,null,"ft"]
[]
[null,"Stream Type:",null,null,"Landscape Type:",null,null,null,null,"Mean Annual Disch.:",null,null,"cfs"]
[]
[null,"Reference Reach Slope:",null,null,null,"ft/ft",null,null,"HUC:"]
[]
[null,"BANKFULL  CHARACTERISTICS"]
[]
[null,"Determined from FIELD MEASUREMENT",null,null,null,null,null,null,"Determined from GAGE DATA ANALYSIS"]
[]
[null,"Bankfull Width (Wbkf)",null,null,null,"ft",null,null,"Bankfull Width (Wbkf)",null,null,null,"ft"]
[]
[null,"Bankfull Mean Depth (dbkf)",null,null,null,"ft",null,null,"Bankfull Mean Depth (dbkf)",null,null,null,"ft"]
[]
[null,"Bankfull XS Area (Abkf)",null,null,null,"ft2",null,null,"Bankfull XS Area (Abkf)",null,null,null,"ft2"]
[]
[null,"Wetted Perimeter (Wp)",null,null,null,"ft",null,null,"Wetted Perimeter (Wp)",null,null,null,"ft"]
[]
[null,"Bankfull Stage (Gage Ht.)",null,null,null,"ft",null,null,"Bankfull Stage (Gage Ht.)",null,null,null,"ft"]
[]
[null,"Est. Mean Velocity (ū)",null,null,null,"ft/sec",null,null,"Mean Velocity (ū)",null,null,null,"ft/sec"]
[]
[null,"Est. BKF. Discharge (Qbkf)",null,null,null,"cfs",null,null,"Bankfull Discharge (Qbkf)",null,null,null,"cfs"]
[]
[null,"Bankfull Discharge associated with field-determined Bankfull Stage ",null,null,null,null,null,null,null,null,null,null,"cfs"]
[]
[null,"Recurrence Interval (R.I.) associated with field-determined Bankfull Stage",null,null,null,null,null,null,null,null,null,null,"yrs"]
[]
[null,"From the Annual Peak Flow Frequency Analysis for the Gage Station, determine:"]
[]
[null,"1.5 Year R.I. Discharge  =",null,null,null,"cfs",null,null,"10 Year R.I. Discharge  =",null,null,null,"cfs"]
[]
[null,"2.0 Year R.I. Discharge  =",null,null,null,"cfs",null,null,"25 Year R.I. Discharge  =",null,null,null,"cfs"]
[]
[null,"5.0 Year R.I. Discharge  =",null,null,null,"cfs",null,null,"50 Year R.I. Discharge  =",null,null,null,"cfs"]
[]
[null,"MEANDER  GEOMETRY"]
[]
[null,"Linear Wavelength (l)",null,null,null,"ft",null,null,"Stream Meander Length (Lm)",null,null,null,"ft"]
[]
[null,"Radius of Curvature (Rc)",null,null,null,"ft",null,null,"Belt Width (Wblt)",null,null,null,"ft/ft"]
[]
[null,"HYDRAULIC  GEOMETRY"]
[]
[null,"Based on USGS Discharge Summary Notes data ( Form 9-207 ) and regression analyses of measured discharge (Q) with the hydraulic parameters of Width (W), Area (A), Mean Depth (d) & Mean Velocity (ū), determine the intercept coefficient (a) and the slope exponent (b) values for a power function of the form Y = aXb, when Y is one of the selected hydraulic parameters and X is a given discharge value (Q)."]
[]
[null,null,null,null,"Width (W)","Depth (d)",null,null,"Area (A)","Vel. (ū)"]
[null," Intercept Coefficient",null,"(a)"]
[null," Slope Exponent",null,"(b)"]
[]
[null,"Hydraulic Radius: R = A / Wp",null,null,null,"ft",null,null," Manning's 'n' at Bankfull Stage",null,null,null,"Coeff."]
[]
[null,"n = 1.49 [(Area) (Hydraulic Radius2/3) (Slope1/2)] / Qbkf"]

{"sheet":"WS 2-2","index":3,"n_rows":67,"n_cols":28,"rows_kept":67,"cut":false,"hidden":false,"merged":[[58,1,58,10],[1,19,5,22],[54,1,54,10],[54,12,56,12],[54,13,56,13],[54,15,56,15],[54,16,56,16],[55,2,55,5],[50,1,50,10],[50,12,52,12],[50,13,52,13],[50,15,52,15],[50,16,52,16],[51,2,51,9],[46,1,46,10],[46,12,48,12],[46,13,48,13],[46,15,48,15],[46,16,48,16],[47,2,47,9],[37,15,39,15],[37,16,39,16],[41,1,41,4],[41,7,41,9],[41,12,42,12],[41,13,42,13],[41,15,42,15],[42,7,42,9],[37,1,37,4],[37,7,37,9],[37,12,39,12],[37,13,39,13],[1,1,1,16],[3,1,3,2],[3,3,3,7],[3,9,3,11],[3,12,3,16],[64,19,66,26],[26,1,27,4],[26,6,27,6],[26,15,27,15],[26,9,26,13],[27,9,27,13],[29,1,29,10],[29,12,29,13],[29,15,29,16],[31,1,31,10],[33,1,33,10],[33,12,35,12],[33,13,35,13],[33,15,35,15],[33,16,35,16],[41,16,42,16],[11,9,12,13],[14,1,15,4],[14,6,15,6],[5,1,5,2],[5,4,5,6],[5,9,5,12],[5,13,5,16],[11,1,12,4],[11,6,12,6],[11,15,12,15],[7,1,7,2],[7,3,7,7],[9,1,9,7],[9,9,9,16],[14,15,15,15],[14,9,14,13],[15,9,15,13],[17,1,18,4],[17,6,18,6],[17,9,17,13],[17,15,18,15],[18,9,18,13],[20,15,21,15],[21,9,21,13],[23,1,24,4],[23,6,24,6],[23,9,23,13],[23,15,24,15],[24,9,24,13],[20,1,21,4],[20,6,21,6],[20,9,20,13]]}
[]
[null,"Bankfull VELOCITY & DISCHARGE Estimates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[]
[null," Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,null,"Location:",null,null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""}]
[]
[null," Date:",null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""},"Stream Type:",null,null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""},null,"Landscape Type:",null,null,null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
[]
[null," Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,null," HUC:"]
[]
[null,"INPUT VARIABLES",null,null,null,null,null,null,null,"OUTPUT VARIABLES"]
[]
[null,"Bankfull Riffle Cross-Sectional Area",null,null,null,null,null,"Abkf",null,"Bankfull Riffle Mean Depth",null,null,null,null,null,{"$f":"IF(OR(G15=\"\",G12=\"\"),\"\",G12/G15)","v":""},"dbkf"]
[null,null,null,null,null,null,null," ( ft2 )",null,null,null,null,null,null,null,null,"( ft )"]
[]
[null,"Bankfull Riffle Width",null,null,null,null,null,"Wbkf",null,"Wetted Perimeter",null,null,null,null,null,{"$f":"IF(OR(P12=\"\",G15=\"\"), \"\", 2*P12+G15)","v":""},"Wp"]
[null,null,null,null,null,null,null," ( ft )",null,"≈ (2 * dbkf) + Wbkf",null,null,null,null,null,null,"( ft )"]
[]
[null,"D84 Particle Size at Riffle",null,null,null,null,null,"D84",null,"D84 Particle Size in Feet",null,null,null,null,null,{"$f":"IF(G18=\"\",\"\",G18/304.8)","v":""},"D84"]
[null,null,null,null,null,null,null," ( mm )",null,"D84 (mm) / 304.8",null,null,null,null,null,null,"( ft )"]
[]
[null,"Bankfull Slope",null,null,null,null,null,"Sbkf",null,"Hydraulic Radius",null,null,null,null,null,{"$f":"IF(OR(G12=\"\",P15=\"\"), \"\", G12/P15)","v":""},"R"]
[null,null,null,null,null,null,null," ( ft / ft )",null,"Abkf / Wp",null,null,null,null,null,null,"( ft )"]
[]
[null,"Gravitational Acceleration",null,null,null,null,32.200000000000003,"g",null,"Relative Roughness",null,null,null,null,null,{"$f":"IF(OR(P21=\"\",P18=\"\"),\"\",P21/P18)","v":""},"R / D84"]
[null,null,null,null,null,null,null," ( ft / sec2 )",null,"R (ft) / D84 (ft)",null,null,null,null,null,null,"( ft / ft )"]
[]
[null,"Drainage Area",null,null,null,null,null,"DA",null,"Shear Velocity",null,null,null,null,null,{"$f":"IF(OR(P21=\"\",G21=\"\"), \"\", (G24*P21*G21)^0.5)","v":""},"u*"]
[null,null,null,null,null,null,null," (mi2)",null," u* = (gRS)½",null,null,null,null,null,null,"( ft / sec)"]
[]
[null,"ESTIMATION METHODS",null,null,null,null,null,null,null,null,null,null,"Bankfull VELOCITY",null,null,"Bankfull DISCHARGE"]
[]
[null,"ū = [ 2.83 + 5.66 * Log { R / D84 } ] u*  ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(P24=\"\",P27=\"\"),\"\",(2.83+5.66*LOG(P24))*P27)","v":""},"ft / sec",null,{"$f":"IF(OR(M32=\"\",G12=\"\",P21=\"\"),\"\",M32*G12)","v":""},"cfs",null,null,null,null,null,null,null,null,null,null,"Figure 2-30.  Friction factor (ū/u*) vs. Manning's roughness coefficient 'n' (Rosgen, 2006b)."]
[]
[null," 2. Roughness Coefficient:  a) Manning's n from Friction Factor/Relative ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(P21=\"\",G21=\"\",J35=\"\"),\"\",1.49*P21^(2/3)*G21^0.5/J35)","v":""},"ft / sec",null,{"$f":"IF(OR(M34=\"\",G12=\"\"),\"\",M34*G12)","v":""},"cfs"]
[null,null,"Roughness (Figs. 2-29, 2-30) ",null,null,null,null,"ū = 1.49*R2/3*S1/2/ n   n ="]
[]
[]
[null," 2. Roughness Coefficient:  ",null,null,null,null,null,"ū = 1.49*R2/3*S1/2/ n",null,null,null,null,{"$f":"IF(OR(G21=\"\",P21=\"\",J39=\"\"),\"\",1.49*P21^(2/3)*G21^0.5/J39)","v":""},"ft / sec",null,{"$f":"IF(OR(M38=\"\",G12=\"\"),\"\",M38*G12)","v":""},"cfs"]
[null,null," b) Manning's n from Stream Type (Fig. 2-31)              ",null,null,null,null,"n ="]
[]
[]
[null," 2. Roughness Coefficient:  ",null,null,null,null,null,"ū = 1.49*R2/3*S1/2/ n",null,null,null,null,{"$f":"IF(OR(G21=\"\",P21=\"\",J44=\"\"),\"\",1.49*P21^(2/3)*G21^0.5/J44)","v":""},"ft / sec",null,{"$f":"IF(OR(M42=\"\",G12=\"\"),\"\",M42*G12)","v":""},"cfs"]
[null,null," c) Manning's n from Jarrett (USGS):               ",null,null,null,null,"n = 0.39*S0.38*R-0.16"]
[null,null,null,null,null,null,null,"n ="]
[]
[]
[null," 3. Other Methods (Hey, Darcy-Weisbach, Chezy C, etc.)",null,null,null,null,null,null,null,null,null,null,null,"ft / sec",null,{"$f":"IF(OR(M47=\"\",G12=\"\"),\"\",M47*G12)","v":""},"cfs"]
[]
[]
[]
[null," 3. Other Methods (Hey, Darcy-Weisbach, Chezy C, etc.)",null,null,null,null,null,null,null,null,null,null,null,"ft / sec",null,{"$f":"IF(OR(M51=\"\",G12=\"\"),\"\",M51*G12)","v":""},"cfs"]
[]
[]
[]
[null," 4. Continuity Equations:       a) USGS Gage Data       ū = Q / A",null,null,null,null,null,null,null,null,null,null,null,"ft / sec",null,{"$f":"IF(OR(M55=\"\",G12=\"\"),\"\",M55*G12)","v":""},"cfs"]
[null,null,"Return Period for Bankfull Q",null,null,null,"Q = ",null,null," year"]
[]
[]
[null," 4. Continuity Equations:       b) Regional Curves      ū = Q / A",null,null,null,null,null,null,null,null,null,null,null,"ft / sec",null,{"$f":"IF(OR(M59=\"\",G12=\"\"),\"\",M59*G12)","v":""},"cfs"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 2-29.  Relative roughness (R/D84) vs. friction factor (ū/u*) (Rosgen, 2006b)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 2-31.  Manning's 'n' by stream type (Rosgen, 2006b)."]

{"sheet":"WS 2-3","index":4,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":false,"merged":[[49,5,49,6],[30,10,32,10],[31,3,32,9],[34,10,37,10],[35,3,37,9],[39,10,42,10],[40,3,42,9],[19,10,20,10],[22,10,24,10],[23,3,24,9],[44,10,47,10],[45,3,47,9],[6,9,6,10],[8,10,9,10],[11,10,13,10],[12,3,13,9],[15,10,17,10],[16,3,17,9],[5,1,5,5],[5,6,5,9],[0,0,0,11],[0,12,50,12],[1,0,50,0],[1,1,1,2],[1,3,1,11],[3,3,3,11],[4,1,4,2],[4,3,4,6],[4,7,4,8],[4,9,4,11],[26,10,28,10],[27,3,28,9],[6,1,6,2],[6,3,6,8],[1,14,3,17],[2,1,2,2],[2,3,2,5],[2,6,2,7],[3,1,3,2]]}
[]
[null,"Stream:  ",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[null,"Basin: ",null,null,null,null,"Drainage Area:  ",null,null,"acres",null," mi2"]
[null,"Location:  ",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""}]
[null,"Twp.&Rge: ",null,null,null,null,null,"Sec.&Qtr.:"]
[null,"Cross-Section Monuments (Lat./Long.):",null,null,null,null,null,null,null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[null,"Observers: ",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
[]
[null,null,null,"Bankfull Width (Wbkf)"]
[null,null,null,"The surface width of the stream  at bankfull stage elevation, in a riffle section.",null,null,null,null,null,null,null,"ft"]
[]
[null,null,null,"Bankfull Mean Depth (dbkf)"]
[null,null,null,"Mean depth of the stream channel cross-section, at bankfull stage elevation, in a riffle section (dbkf = Abkf / Wbkf)."]
[null,null,null,null,null,null,null,null,null,null,null,"ft"]
[]
[null,null,null,"Bankfull Cross-Sectional Area (Abkf)"]
[null,null,null,"Area of the stream channel cross-section, at bankfull stage elevation, in a riffle section."]
[null,null,null,null,null,null,null,null,null,null,null,"ft2"]
[]
[null,null,null,"Width/Depth Ratio (Wbkf / dbkf)"]
[null,null,null,"Bankfull Width divided by Bankfull Mean Depth, in a riffle section.",null,null,null,null,null,null,null,"ft/ft"]
[]
[null,null,null,"Bankfull Maximum Depth (dmax)"]
[null,null,null,"Maximum depth of the bankfull channel cross-section, or distance between the bankfull stage and Thalweg elevations, in a riffle section."]
[null,null,null,null,null,null,null,null,null,null,null,"ft"]
[]
[null,null,null,"Flood-Prone Area Width (Wfpa)"]
[null,null,null,"Width of the channel at an elevation that is twice the Bankfull Maximum Depth, measured perpendicular to the fall line of the valley in a riffle section."]
[null,null,null,null,null,null,null,null,null,null,null,"ft"]
[]
[null,null,null,"Entrenchment Ratio (ER) "]
[null,null,null,"The Flood-Prone Area Width divided by Bankfull Width (Wfpa / Wbkf), in a riffle section."]
[null,null,null,null,null,null,null,null,null,null,null,"ft/ft"]
[]
[null,null,null,"Channel Materials (Particle Size Index D50)"]
[null,null,null,"The D50 particle size index represents the median or dominant diameter of channel materials, as sampled proportionately from the channel surface between the bankfull stage and Thalweg elevations."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"mm"]
[]
[null,null,null,"Average Water Surface Slope (S) "]
[null,null,null,"The elevation difference of water surface measurements over the stream length between two similar bed features (e.g., start of riffle to start of last riffle) for several riffle−pool or step−pool sequences, representing channel gradient."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"ft/ft"]
[]
[null,null,null,"Channel Sinuosity (k) "]
[null,null,null,"An index of channel pattern determined from stream length divided by valley length (SL / VL), or from  valley slope divided by average water surface slope (Sval / S). "]
[]
[null,null,null,null,null,null,null,null,null,null,null,"ft/ft"]

{"sheet":"WS 2-4a","index":5,"n_rows":87,"n_cols":35,"rows_kept":87,"cut":false,"hidden":false,"merged":[[1,34,5,37],[46,24,46,31],[38,24,42,31],[39,23,41,23],[25,24,25,27],[25,28,25,31],[27,24,27,27],[27,28,27,31],[16,24,16,27],[16,28,16,31],[18,24,18,27],[18,28,18,31],[1,23,2,31],[84,0,84,20],[85,0,85,20],[86,0,86,20],[78,22,78,27],[80,24,82,31],[74,24,76,31],[74,23,75,23],[71,0,71,20],[72,0,83,0],[73,1,73,5],[82,10,82,16],[67,24,72,31],[68,23,69,23],[52,0,52,20],[52,24,54,27],[52,28,54,31],[53,0,70,0],[55,24,55,27],[59,24,59,27],[65,24,65,27],[65,28,65,31],[63,24,63,27],[63,28,63,31],[55,28,55,31],[61,24,61,27],[61,28,61,31],[39,0,39,20],[40,0,51,0],[44,24,44,31],[48,24,48,27],[48,28,48,31],[50,10,50,16],[50,24,50,27],[50,28,50,31],[20,0,20,20],[20,24,22,27],[20,28,22,31],[21,0,38,0],[23,24,23,27],[23,28,23,31],[37,22,37,26],[29,24,35,31],[2,0,19,0],[3,22,3,31],[4,24,6,31],[8,24,8,31],[12,24,12,27],[12,28,12,31],[14,24,14,27],[14,28,14,31],[0,0,0,1],[0,2,0,8],[0,9,0,11],[0,12,0,20],[1,0,1,1],[1,2,1,6],[1,14,1,15],[1,16,1,17],[1,18,1,20],[1,11,1,13],[1,8,1,10]]}
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,null,null,"Location:",null,null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""},null,null,"Landscape Type:",null,null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""},null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""},null,null,null,null,"Instructions to Complete Bed Feature Dimensions (Worksheet 2-4a)",null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[]
[null,"Riffle Dimensions*, **, ***",null,null,null,null,"Mean","Min.","Max.","Riffle Dimensions & Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min.","Max.",null,null,"Riffle Dimensions"]
[null,"Riffle Width (Wbkf)",null,null,null,null,null,null,null,"ft","Riffle Cross-Sectional Area (Abkf) (ft2)",null,null,null,null,null,null,null,null,null,null,null,null,"1.","Survey Riffle cross-sections; be sure to select and survey only those cross-sections that are representative of the reach, determined during the \"toothpick survey.\" Multiple Riffle cross-sections are needed to determine a range of values that represent Riffle dimensions."]
[]
[null,"Riffle Mean Depth (dbkf)",null,null,null,null,null,null,null,"ft","Riffle Width/Depth Ratio (Wbkf / dbkf)"]
[]
[null,"Riffle Maximum Depth (dmax)",null,null,null,null,null,null,null,"ft","Riffle Max Depth to Riffle Mean Depth (dmax / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,"2.","Plot all Riffle cross-sections."]
[]
[null,"Width of Flood-Prone Area (Wfpa)",null,null,null,null,null,null,null,"ft","Entrenchment Ratio (Wfpa / Wbkf)",null,null,null,null,null,null,null,null,null,null,null,null,"3.","For each Riffle cross-section, calculate all dimensions and dimensionless ratios:"]
[]
[null,"Riffle Inner Berm Width (Wib)",null,null,null,null,null,null,null,"ft","Riffle Inner Berm Width to Riffle Width (Wib / Wbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,"i. Riffle Width (Wbkf)",null,null,null,"ii. Riffle Mean Depth (dbkf)"]
[]
[null,"Riffle Inner Berm Depth (dib)",null,null,null,null,null,null,null,"ft","Riffle Inner Berm Depth to Mean Depth (dib / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,"iii. Riffle Cross-Sectional Area (Abkf)",null,null,null,"iv. Riffle Width/Depth Ratio (Wbkf/dbkf)"]
[]
[null,"Riffle Inner Berm Area (Aib)",null,null,null,null,null,null,null,"ft2","Riffle Inner Berm Area to Riffle Area (Aib / Abkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,"v. Riffle Maximum Depth (dmax)",null,null,null,"vi. Riffle Max Depth to Riffle Mean Depth (dmax/dbkf)"]
[]
[null,"Riffle Inner Berm W/d Ratio (Wib / dib)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"vii. Width of Flood-Prone Area (Wfpa)",null,null,null,"viii.  Entrenchment Ratio (Wfpa/Wbkf)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ix. Riffle Inner Berm Width (Wib)",null,null,null,"x. Riffle Inner Berm Width to Riffle Width (Wib/Wbkf)"]
[]
[null,"Pool Dimensions*, **, ***",null,null,null,null,"Mean","Min.","Max.","Pool Dimensions & Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min.","Max."]
[null,"Pool Width (Wbkfp)",null,null,null,null,null,null,null,"ft","Pool Width to Riffle Width (Wbkfp / Wbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,"xi. Riffle Inner Berm Depth (dib)",null,null,null,"xii. Riffle Inner Berm Depth to Mean Depth (dib/dbkf)"]
[]
[null,"Pool Mean Depth (dbkfp)",null,null,null,null,null,null,null,"ft","Pool Mean Depth to Riffle Mean Depth (dbkfp / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,"xiii. Riffle Inner Berm Area (Aib)",null,null,null,"xiv. Riffle Inner Berm Area to Riffle Area (Aib/Abkf)"]
[]
[null,"Pool Cross-Sectional Area (Abkfp)",null,null,null,null,null,null,null,"ft","Pool Area to Riffle Area (Abkfp / Abkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,"xv. Riffle Inner Berm Width/Depth Ratio (Wib/dib)"]
[]
[null,"Pool Maximum Depth (dmaxp)",null,null,null,null,null,null,null,"ft","Pool Max Depth to Riffle Mean Depth (dmaxp / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,"4.","Select one Riffle cross-section that is most representative of the reach; the dimensions from this cross-section are used for stream classification and as the normalization parameters to create the dimensionless ratios. Record the respective Riffle Width, Riffle Mean Depth, and Riffle Cross-Sectional Area in the \"Riffle Dimensions\" section in Worksheet 2-4a to represent the mean values for these three variables. For all remaining variables, determine the mean, minimum, and maximum Riffle dimensions that represent the values from all Riffle cross-sections; record all values in Worksheet 2-4a.  "]
[]
[null,"Pool Inner Berm Width (Wibp)",null,null,null,null,null,null,null,"ft","Pool Inner Berm Width to Pool Width (Wibp / Wbkfp)"]
[]
[null,"Pool Inner Berm Depth (dibp)",null,null,null,null,null,null,null,"ft","Pool Inner Berm Depth to Pool Depth (dibp / dbkfp)"]
[]
[null,"Pool Inner Berm Area (Aibp)",null,null,null,null,null,null,null,"ft2","Pool Inner Berm Area to Pool Area (Aibp / Abkfp)"]
[]
[null,"Point Bar Slope (Spb)",null,null,null,null,null,null,null,"ft/ft","Pool Inner Berm Width/Depth Ratio (Wibp / dibp)",null,null,null,null,null,null,null,null,null,null,null,"Pool Dimensions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey Pool cross-sections; be sure to select and survey only those cross-sections that are representative of the reach, determined during the \"toothpick survey.\" Multiple Pool cross-sections are needed to determine an average and a range of values that represent Pool dimensions."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1."]
[]
[null,"Run Dimensions*",null,null,null,null,"Mean","Min.","Max.","Run Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min.","Max."]
[null,"Run Width (Wbkfr)",null,null,null,null,null,null,null,"ft","Run Width to Riffle Width (Wbkfr / Wbkf)"]
[]
[null,"Run Mean Depth (dbkfr)",null,null,null,null,null,null,null,"ft","Run Mean Depth to Riffle Mean Depth (dbkfr / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,"2.","Plot all Pool cross-sections."]
[]
[null,"Run Cross-Sectional Area (Abkfr)",null,null,null,null,null,null,null,"ft","Run Area to Riffle Area (Abkfr / Abkf)",null,null,null,null,null,null,null,null,null,null,null,null,"3.","For each Pool cross-section, calculate all dimensions and dimensionless ratios:"]
[]
[null,"Run Maximum Depth (dmaxr)",null,null,null,null,null,null,null,"ft","Run Max Depth to Riffle Mean Depth (dmaxr / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,"i. Pool Width (Wbkfp)",null,null,null,"ii. Pool Width to Riffle Width (Wbkfp/Wbkf)*"]
[]
[null,"Run Width/Depth Ratio (Wbkfr / dbkfr)",null,null,null,null,null,null,null,"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"iii. Pool Mean Depth (dbkfp)",null,null,null,"iv. Pool Mean Depth to Riffle Mean Depth (dbkfp/dbkf)*"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"iii. Pool Mean Depth (dbkfp)",null,null,null,"iv. Pool Mean Depth to Riffle Mean Depth (dbkfp/dbkf)*"]
[]
[null,"Glide Dimensions*",null,null,null,null,"Mean","Min.","Max.","Glide Dimensions & Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min.","Max."]
[null,"Glide Width (Wbkfg)",null,null,null,null,null,null,null,"ft","Glide Width to Riffle Width (Wbkfg / Wbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,"v. Pool Cross-Sectional Area (Abkfp)",null,null,null,"vi. Pool Area to Riffle Area (Abkfp/Abkf)*"]
[]
[null,"Glide Mean Depth (dbkfg)",null,null,null,null,null,null,null,"ft","Glide Mean Depth to Riffle Mean Depth (dbkfg / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,"vii. Pool Maximum Depth (dmaxp)",null,null,null,"viii. Pool Max Depth to Riffle Mean Depth (dmaxp/dbkf)*"]
[]
[null,"Glide Cross-Sectional Area (Abkfg)",null,null,null,null,null,null,null,"ft","Glide Area to Riffle Area (Abkfg / Abkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,"ix. Pool Inner Berm Width (Wibp)",null,null,null,"x. Pool Inner Berm Width to Pool Width (Wibp/Wbkfp)"]
[]
[null,"Glide Maximum Depth (dmaxg)",null,null,null,null,null,null,null,"ft","Glide Max Depth to Riffle Mean Depth (dmaxg / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,"xi. Pool Inner Berm Depth (dibp)",null,null,null,"xii. Pool Inner Berm Depth to Pool Depth (dibp/dbkfp)"]
[]
[null,"Glide Width/Depth Ratio (Wbkfg / dbkfg)",null,null,null,null,null,null,null,"ft/ft","Glide Inner Berm Width/Depth Ratio (Wibg / dibg)",null,null,null,null,null,null,null,null,null,null,null,null,null,"xiii. Pool Inner Berm Area (Aibp)",null,null,null,"xiv. Pool Inner Berm Area to Pool Area (Aibp/Abkfp)"]
[]
[null,"Glide Inner Berm Width (Wibg)",null,null,null,null,null,null,null,"ft","Glide Inner Berm Width to Glide Width (Wibg/Wbkfg)",null,null,null,null,null,null,null,null,null,null,null,null,null,"xv. Point Bar Slope (Spb)",null,null,null,"xvi. Pool Inner Berm Width/Depth Ratio (Wibp/dibp)"]
[]
[null,"Glide Inner Berm Depth (dibg)",null,null,null,null,null,null,null,"ft","Glide Inner Berm Depth to Glide Depth (dibg / dbkfg)",null,null,null,null,null,null,null,null,null,null,null,null,"*","The normalization parameters of Riffle Width (Wbkf), Riffle Mean Depth (dbkf), and Riffle Area (Abkf) to create the pool dimensionless ratios (bolded above) use the Riffle dimensions from the representative Riffle cross-section selected for use for stream classification. These normalization parameters are recorded as the mean values of Riffle Width, Riffle Mean Depth, and Riffle Cross-Sectional Area in Worksheet 2-4a."]
[]
[null,"Glide Inner Berm Area (Aibg)",null,null,null,null,null,null,null,"ft2","Glide Inner Berm Area to Glide Area (Aibg / Abkfg)"]
[]
[]
[]
[null,"Step Dimensions**",null,null,null,null,"Mean","Min.","Max.","Step Dimensionless Ratios****",null,null,null,null,null,null,null,"Mean","Min.","Max."]
[null,"Step Width (Wbkfs)",null,null,null,null,null,null,null,"ft","Step Width to Riffle Width (Wbkfs / Wbkf)",null,null,null,null,null,null,null,null,null,null,null,null,"4.","Determine the mean, minimum, and maximum Pool dimensions that represent the values from all Pool cross-sections. Complete the \"Pool Dimensions\" section in Worksheet 2-4a using the determined mean, minimum, and maximum values.  "]
[]
[null,"Step Mean Depth (dbkfs)",null,null,null,null,null,null,null,"ft","Step Mean Depth to Riffle Mean Depth (dbkfs / dbkf)"]
[]
[null,"Step Cross-Sectional Area (Abkfs)",null,null,null,null,null,null,null,"ft","Step Area to Riffle Area (Abkfs / Abkf)",null,null,null,null,null,null,null,null,null,null,null,"Run, Glide, & Step Dimensions"]
[]
[null,"Step Maximum Depth (dmaxs)",null,null,null,null,null,null,null,"ft","Step Max Depth to Riffle Mean Depth (dmaxs / dbkf)",null,null,null,null,null,null,null,null,null,null,null,null,null,"The instructions to complete the \"Run Dimensions,\" \"Glide Dimensions,\" and \"Step Dimensions\" in Worksheet 2-4a are similar to the Pool Instructions above, but instead are calculated for the respective bed feature."]
[]
[null,"Step Width/Depth Ratio (Wbkfs / dbkfs)",null,null,null,null,null,null,null,"ft/ft"]
[]
["*Riffle–Pool system (i.e., C, E, F stream types) bed features include riffles, runs, pools, and glides."]
["**Step–Pool system (i.e., A, B, G stream types) bed features include riffles, rapids, chutes, pools, and steps (note: include rapids and chutes in riffle category)."]
["***Convergence-Divergence system (i.e., D stream types) bed features include riffles and pools; cross-sections taken at riffles for classification purposes."]

{"sheet":"WS 2-4b","index":6,"n_rows":76,"n_cols":23,"rows_kept":76,"cut":false,"hidden":false,"merged":[[72,17,72,18],[76,0,76,20],[72,1,72,3],[72,4,72,5],[72,6,72,7],[72,8,72,9],[72,12,72,13],[72,14,72,15],[61,0,73,0],[61,17,61,19],[66,14,66,15],[66,17,66,18],[68,17,68,18],[70,1,70,3],[70,4,70,5],[70,6,70,7],[70,8,70,9],[70,12,70,13],[70,14,70,15],[70,17,70,18],[68,1,68,3],[68,4,68,5],[68,6,68,7],[68,8,68,9],[68,12,68,13],[68,14,68,15],[66,1,66,3],[66,4,66,5],[66,6,66,7],[66,8,66,9],[66,12,66,13],[64,14,64,15],[62,1,62,3],[62,4,62,5],[62,6,62,7],[64,17,64,18],[64,1,64,3],[64,4,64,5],[64,6,64,7],[64,8,64,9],[64,12,64,13],[57,9,57,16],[59,0,59,20],[62,8,62,9],[62,12,62,13],[62,14,62,15],[62,17,62,18],[28,0,28,20],[29,0,56,0],[30,4,30,5],[30,13,30,14],[32,4,32,5],[32,7,32,12],[32,13,32,14],[34,7,34,10],[35,7,35,10],[49,9,49,16],[51,9,51,16],[53,9,53,16],[55,9,55,16],[9,0,9,20],[10,0,27,0],[18,1,18,4],[18,9,18,16],[20,9,20,16],[22,9,22,16],[24,9,24,16],[26,1,26,4],[26,9,26,16],[1,22,5,25],[3,0,8,0],[5,11,5,12],[5,17,5,19],[7,11,7,12],[7,17,7,18],[1,8,1,10],[1,11,1,13],[0,0,0,1],[0,2,0,8],[0,9,0,11],[0,12,0,20],[1,0,1,1],[1,2,1,6],[1,14,1,15],[1,16,1,17],[1,18,1,20]]}
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,null,null,"Location:",null,null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""},null,null,"Landscape Type:",null,null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""},null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""},null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[]
[]
[]
[null,"Streamflow: Estimated Mean Velocity at Bankfull Stage (ūbkf)",null,null,null,null,null,null,null,null,null,null,null,"ft/sec","Estimation Method"]
[]
[null,"Streamflow: Estimated Discharge at Bankfull Stage (Qbkf)",null,null,null,null,null,null,null,null,null,null,null,"cfs","Drainage Area",null,null,null,null,"mi2"]
[]
[]
[]
[null,"Geometry",null,null,null,"Mean","Min.","Max.",null,"Dimensionless Geometry Ratios",null,null,null,null,null,null,null,"Mean","Min.","Max."]
[null,"Linear Wavelength (l)",null,null,null,null,null,null,"ft","Linear Wavelength to Riffle Width (l / Wbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F13=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!F13/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(G13=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!G13/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(H13=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!H13/'WS 2-4a'!$G5)","v":""}]
[]
[null,"Stream Meander Length (Lm)",null,null,null,null,null,null,"ft","Stream Meander Length Ratio (Lm / Wbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F15=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!F15/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(G15=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!G15/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(H15=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!H15/'WS 2-4a'!$G5)","v":""}]
[]
[null,"Radius of Curvature (Rc)",null,null,null,null,null,null,"ft","Radius of Curvature to Riffle Width (Rc / Wbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F17=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!F17/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(G17=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!G17/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(H17=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!H17/'WS 2-4a'!$G5)","v":""}]
[]
[null,"Belt Width (Wblt)",null,null,null,null,null,null,"ft","Meander Width Ratio (Wblt / Wbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F19=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!F19/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(G19=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!G19/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(H19=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!H19/'WS 2-4a'!$G5)","v":""}]
[]
[null,"Arc Length (La)",null,null,null,null,null,null,"ft","Arc Length to Riffle Width (La / Wbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F21=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!F21/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(G21=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!G21/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(H21=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!H21/'WS 2-4a'!$G5)","v":""}]
[]
[null,"Riffle Length (Lr)",null,null,null,null,null,null,"ft","Riffle Length to Riffle Width (Lr / Wbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F23=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!F23/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(G23=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!G23/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(H23=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!H23/'WS 2-4a'!$G5)","v":""}]
[]
[null,"Individual Pool Length (Lp)",null,null,null,null,null,null,"ft","Individual Pool Length to Riffle Width (Lp / Wbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F25=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!F25/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(G25=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!G25/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(H25=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!H25/'WS 2-4a'!$G5)","v":""}]
[]
[null,"Pool-to-Pool Spacing (Ps)",null,null,null,null,null,null,"ft","Pool-to-Pool Spacing to Riffle Width (Ps / Wbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F27=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!F27/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(G27=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!G27/'WS 2-4a'!$G5)","v":""},{"$f":"IF(OR(H27=\"\",'WS 2-4a'!$G5=\"\"),\"\",'WS 2-4b'!H27/'WS 2-4a'!$G5)","v":""}]
[]
[]
[]
[null,"Valley Slope (Sval)",null,null,null,null,"ft/ft","Average Water Surface Slope (S)",null,null,null,null,null,null,null,"ft/ft","Sinuosity (Sval / S)",null,null,{"$f":"IF(OR($E$31=\"\",$N$31=\"\"),\"\",$E$31/$N$31)","v":""}]
[]
[null,"Stream Length (SL)",null,null,null,null,"ft","Valley Length (VL)",null,null,null,null,null,null,null,"ft","Sinuosity (SL / VL)",null,null,{"$f":"IF(OR($E$33=\"\",$N$33=\"\"),\"\",$E$33/$N$33)","v":""}]
[]
[null,"Low Bank Height",null,null,"start",null,"ft","Bankfull  Max Depth",null,null,null,"start",null,"ft","Bank-Height Ratio (BHR)",null,null,null,"start",{"$f":"IF(OR(F35=\"\",M35=\"\"),\"\",F35/M35)","v":""}]
[null,"(LBH)",null,null,"end",null,"ft","(dmax)",null,null,null,"end",null,"ft","(LBH / dmax)",null,null,null,"end",{"$f":"IF(OR(F36=\"\",M36=\"\"),\"\",F36/M36)","v":""}]
[]
[null,"Facet Slopes",null,null,null,"Mean","Min.","Max.","Dimensionless Facet Slope Ratios",null,null,null,null,null,null,null,null,"Mean","Min.","Max."]
[null,"Riffle Slope (Srif)",null,null,null,null,null,null,"ft/ft","Riffle Slope to Average Water Surface Slope (Srif / S)",null,null,null,null,null,null,null,{"$f":"IF(OR(F39=\"\",$N$31=\"\"),\"\",F39/$N$31)","v":""},{"$f":"IF(OR(G39=\"\",$N$31=\"\"),\"\",G39/$N$31)","v":""},{"$f":"IF(OR(H39=\"\",$N$31=\"\"),\"\",H39/$N$31)","v":""}]
[]
[null,"Run Slope (Srun)",null,null,null,null,null,null,"ft/ft","Run Slope to Average Water Surface Slope (Srun / S)",null,null,null,null,null,null,null,{"$f":"IF(OR(F41=\"\",$N$31=\"\"),\"\",F41/$N$31)","v":""},{"$f":"IF(OR(G41=\"\",$N$31=\"\"),\"\",G41/$N$31)","v":""},{"$f":"IF(OR(H41=\"\",$N$31=\"\"),\"\",H41/$N$31)","v":""}]
[]
[null,"Pool Slope (Sp)",null,null,null,null,null,null,"ft/ft","Pool Slope to Average Water Surface Slope (Sp / S)",null,null,null,null,null,null,null,{"$f":"IF(OR(F43=\"\",$N$31=\"\"),\"\",F43/$N$31)","v":""},{"$f":"IF(OR(G43=\"\",$N$31=\"\"),\"\",G43/$N$31)","v":""},{"$f":"IF(OR(H43=\"\",$N$31=\"\"),\"\",H43/$N$31)","v":""}]
[]
[null,"Glide Slope (Sg)",null,null,null,null,null,null,"ft/ft","Glide Slope to Average Water Surface Slope (Sg / S)",null,null,null,null,null,null,null,{"$f":"IF(OR(F45=\"\",$N$31=\"\"),\"\",F45/$N$31)","v":""},{"$f":"IF(OR(G45=\"\",$N$31=\"\"),\"\",G45/$N$31)","v":""},{"$f":"IF(OR(H45=\"\",$N$31=\"\"),\"\",H45/$N$31)","v":""}]
[]
[null,"Step Slope (Ss)",null,null,null,null,null,null,"ft/ft","Step Slope to Average Water Surface Slope (Ss / S)",null,null,null,null,null,null,null,{"$f":"IF(OR(F47=\"\",$N$31=\"\"),\"\",F47/$N$31)","v":""},{"$f":"IF(OR(G47=\"\",$N$31=\"\"),\"\",G47/$N$31)","v":""},{"$f":"IF(OR(H47=\"\",$N$31=\"\"),\"\",H47/$N$31)","v":""}]
[]
[null,"Max Depthsa",null,null,null,"Mean","Min.","Max.","Dimensionless Depth Ratios",null,null,null,null,null,null,null,null,"Mean","Min.","Max."]
[null,"Max Riffle Depth (dmax)",null,null,null,null,null,null,"ft","Max Riffle Depth to Mean Riffle Depth (dmax / dbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F50=\"\",'WS 2-4a'!G7=\"\"),\"\",F50/'WS 2-4a'!G7)","v":""},{"$f":"IF(OR(G50=\"\",'WS 2-4a'!G7=\"\"),\"\",G50/'WS 2-4a'!G7)","v":""},{"$f":"IF(OR(H50=\"\",'WS 2-4a'!G7=\"\"),\"\",H50/'WS 2-4a'!G7)","v":""}]
[]
[null,"Max Run Depth (dmaxr)",null,null,null,null,null,null,"ft","Max Run Depth to Mean Riffle Depth (dmaxr / dbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F52=\"\",'WS 2-4a'!G7=\"\"),\"\",F52/'WS 2-4a'!G7)","v":""},{"$f":"IF(OR(G52=\"\",'WS 2-4a'!G7=\"\"),\"\",G52/'WS 2-4a'!G7)","v":""},{"$f":"IF(OR(H52=\"\",'WS 2-4a'!G7=\"\"),\"\",H52/'WS 2-4a'!G7)","v":""}]
[]
[null,"Max Pool Depth (dmaxp)",null,null,null,null,null,null,"ft","Max Pool Depth to Mean Riffle Depth (dmaxp / dbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F54=\"\",'WS 2-4a'!G7=\"\"),\"\",F54/'WS 2-4a'!G7)","v":""},{"$f":"IF(OR(G54=\"\",'WS 2-4a'!G7=\"\"),\"\",G54/'WS 2-4a'!G7)","v":""},{"$f":"IF(OR(H54=\"\",'WS 2-4a'!G7=\"\"),\"\",H54/'WS 2-4a'!G7)","v":""}]
[]
[null,"Max Glide Depth (dmaxg)",null,null,null,null,null,null,"ft","Max Glide Depth to Mean Riffle Depth (dmaxg / dbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F56=\"\",'WS 2-4a'!G7=\"\"),\"\",F56/'WS 2-4a'!G7)","v":""},{"$f":"IF(OR(G56=\"\",'WS 2-4a'!G7=\"\"),\"\",G56/'WS 2-4a'!G7)","v":""},{"$f":"IF(OR(H56=\"\",'WS 2-4a'!G7=\"\"),\"\",H56/'WS 2-4a'!G7)","v":""}]
[]
[null,"Max Step Depth (dmaxs)",null,null,null,null,null,null,"ft","Max Step Depth to Mean Riffle Depth (dmaxs / dbkf)",null,null,null,null,null,null,null,{"$f":"IF(OR(F58=\"\",'WS 2-4a'!G7=\"\"),\"\",F58/'WS 2-4a'!G7)","v":""},{"$f":"IF(OR(G58=\"\",'WS 2-4a'!G7=\"\"),\"\",G58/'WS 2-4a'!G7)","v":""},{"$f":"IF(OR(H58=\"\",'WS 2-4a'!G7=\"\"),\"\",H58/'WS 2-4a'!G7)","v":""}]
[]
[]
[]
[null,null,null,null,"Reachb",null,"Rifflec",null,"Bar",null,null,null,"Reachb",null,"Rifflec",null,"Bar","Protrusion Heightd"]
[null,"% Silt/Clay",null,null,null,null,null,null,null,null,null,"D16",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Sand",null,null,null,null,null,null,null,null,null,"D35",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Gravel",null,null,null,null,null,null,null,null,null,"D50",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Cobble",null,null,null,null,null,null,null,null,null,"D84",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Boulder",null,null,null,null,null,null,null,null,null,"D95",null,null,null,null,null,null,null,"mm"]
[]
[null,"% Bedrock",null,null,null,null,null,null,null,null,null,"D100",null,null,null,null,null,null,null,"mm"]
[]
["a Mean, Min., and Max. depths are measured from Thalweg to bankfull at mid-point of feature for riffles, runs, and steps, the deepest part of pools, and at the tail-out of glides."]
["b Composite sample of riffles and pools within the designated reach.",null,null,null,null,null,null,null,null,null,null,"c Active bed of a riffle.",null,null,null,"d Height of roughness feature above bed."]

{"sheet":"WS 2-5","index":7,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[0,7,0,12],[1,1,1,2],[1,4,1,5],[1,7,1,8],[1,11,1,12],[2,0,44,0],[3,1,4,3],[5,1,7,1],[5,2,7,3],[9,1,11,1],[9,2,11,3],[13,1,15,1],[13,2,15,3],[17,1,19,1],[17,2,19,3],[21,1,23,1],[21,2,23,3],[25,1,27,1],[25,2,27,3],[29,1,31,1],[29,2,31,3],[45,1,45,11],[33,1,35,1],[33,2,35,3],[37,1,39,1],[37,2,39,3],[41,1,43,1],[41,2,43,3]]}
[null,"Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,"Location:",{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""}]
[null,"Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""},"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""},"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[]
[null,"Pool Type",null,null,null,"Pool Length","Pool Max Depth","Pool Slope",null,"Pool Length to Riffle Width","Pool Max Depth to Riffle Mean Depth","Pool Slope to Average Slope"]
[null,null,null,null,null,"(Lp)","(dmaxp)","(Sp)",null,"(Lp / Wbkf)","(dmaxp / dbkf)","(Sp / S)"]
[null,"1.","Lateral Scour Pool (LSP)",null,"Mean",null,null,null,"Mean"]
[null,null,null,null,"Min.",null,null,null,"Min."]
[null,null,null,null,"Max.",null,null,null,"Max."]
[]
[null,"2.","Contraction Scour Pool (CSP)",null,"Mean",null,null,null,"Mean"]
[null,null,null,null,"Min.",null,null,null,"Min."]
[null,null,null,null,"Max.",null,null,null,"Max."]
[]
[null,"3.","Step/Pool (SP)",null,"Mean",null,null,null,"Mean"]
[null,null,null,null,"Min.",null,null,null,"Min."]
[null,null,null,null,"Max.",null,null,null,"Max."]
[]
[null,"4.","Backwater Pool (BWP)",null,"Mean",null,null,null,"Mean"]
[null,null,null,null,"Min.",null,null,null,"Min."]
[null,null,null,null,"Max.",null,null,null,"Max."]
[]
[null,"5.","Plunge Pool (PP)",null,"Mean",null,null,null,"Mean"]
[null,null,null,null,"Min.",null,null,null,"Min."]
[null,null,null,null,"Max.",null,null,null,"Max."]
[]
[null,"6.","Pocket Water Pool (PWP)",null,"Mean",null,null,null,"Mean"]
[null,null,null,null,"Min.",null,null,null,"Min."]
[null,null,null,null,"Max.",null,null,null,"Max."]
[]
[null,"7.","Lateral Protrusion Pool (LPP)",null,"Mean",null,null,null,"Mean"]
[null,null,null,null,"Min.",null,null,null,"Min."]
[null,null,null,null,"Max.",null,null,null,"Max."]
[]
[null,"8.","Straight Dissipator Pool (SDP)",null,"Mean",null,null,null,"Mean"]
[null,null,null,null,"Min.",null,null,null,"Min."]
[null,null,null,null,"Max.",null,null,null,"Max."]
[]
[null,"9.","Converging Confluence Pool (CCP)",null,"Mean",null,null,null,"Mean"]
[null,null,null,null,"Min.",null,null,null,"Min."]
[null,null,null,null,"Max.",null,null,null,"Max."]
[]
[null,"10.","Compound Pool (CP)",null,"Mean",null,null,null,"Mean"]
[null,null,null,null,"Min.",null,null,null,"Min."]
[null,null,null,null,"Max.",null,null,null,"Max."]

{"sheet":"Level III","index":8,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,2,2,2]]}
[null,"Level III: River Stability Prediction","River Stability Field Guide Page Number"]
[null,"Forms & Worksheets"]
[]
[]
["1.","Worksheet 3-1.  Riparian vegetation composition and density used for channel stability assessment.","Page 3-6"]
["2.","Worksheet 3-2.  Flow regime variables that influence channel characteristics, sediment regime, and biological interpretations.","Page 3-11"]
["3.","Worksheet 3-3.  Stream order and stream size categories for stratification by stream type.","Page 3-14"]
["4.","Worksheet 3-4.  Meander pattern relations used for interpretations for river stability.","Page 3-16"]
["5.","Worksheet 3-5.  Depositional patterns used for stability assessment interpretations.","Page 3-20"]
["6.","Worksheet 3-6.  Various categories of in-channel debris, dams, and channel blockages used to evaluate channel stability.","Page 3-26"]
["7.","Worksheet 3-7.  Relationship of Bank-Height Ratio (BHR) ranges to corresponding stream stability ratings to infer degree of channel incision.","Page 3-34"]
["8.","Worksheet 3-8.  Stability ratings based on departure of width/depth ratio from reference condition.","Page 3-38"]
["9.","Worksheet 3-9.  Degree of confinement based on Meander Width Ratio (MWR) divided by reference condition Meander Width Ratio (MWRref).","Page 3-43"]
["10.","Worksheet 3-10.  Pfankuch (1975) channel stability rating procedure, as modified by Rosgen.","Pages 3-46           to 3-47"]
["11.","Worksheet 3-11.  Form to calculate an overall Bank Erosion Hazard Index (BEHI) rating.  Use Figure 3-7 to determine individual BEHI scores.","Page 3-54"]
["12.","Worksheet 3-12.  Various field methods of estimating Near-Bank Stress (NBS) risk ratings to calculate an erosion rate.","Page 3-72"]
["13.","Worksheet 3-13.  Annual streambank erosion estimates for various study reaches.","Page 3-89"]
["14.","Worksheet 3-14.  Sediment competence calculation form to assess bed stability.","Page 3-101"]
["15.","Worksheet 3-15.  Stability ratings for stream type stage shifts.","Page 3-105"]
["16.","Worksheet 3-16.  Lateral stability prediction summary.","Page 3-108"]
["17.","Worksheet 3-17.  Vertical stability prediction for excess deposition and aggradation.","Page 3-111"]
["18.","Worksheet 3-18.  Vertical stability prediction for channel incision and degradation.","Page 3-113"]
["19.","Worksheet 3-19.  Channel enlargement prediction summary.","Page 3-115"]
["20.","Worksheet 3-20.  Overall sediment supply rating determined from individual stability rating categories.","Page 3-118"]
["21.","Worksheet 3-21.  Summary of stability condition categories.","Page 3-122"]

{"sheet":"WS 3-1","index":9,"n_rows":35,"n_cols":20,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,8,5,8],[4,1,4,2],[4,3,4,4],[4,11,4,12],[4,13,4,16],[1,1,1,16],[2,1,2,2],[2,3,2,7],[2,9,2,16],[1,19,2,22],[6,1,6,2],[6,3,6,10],[6,11,6,12],[6,13,6,16],[7,1,7,2],[7,3,7,10],[7,11,7,12],[7,13,7,16],[8,1,8,3],[8,4,8,5],[8,6,8,7],[8,8,8,13],[9,14,9,16],[9,1,14,1],[9,2,14,3],[9,4,14,5],[9,6,14,7],[8,14,8,16],[11,14,11,16],[13,8,13,13],[13,14,13,16],[14,8,14,13],[14,14,14,16],[12,8,12,13],[12,14,12,16],[9,8,9,13],[10,8,10,13],[10,14,10,16],[11,8,11,13],[15,6,16,7],[15,8,16,13],[15,14,15,16],[23,8,24,13],[23,14,23,16],[17,1,22,1],[17,2,22,3],[17,6,22,7],[17,8,17,13],[17,14,17,16],[18,8,18,13],[18,14,18,16],[19,8,19,13],[19,14,19,16],[20,8,20,13],[20,14,20,16],[21,8,21,13],[21,14,21,16],[22,8,22,13],[22,14,22,16],[29,14,29,16],[30,8,30,13],[30,14,30,16],[28,8,28,13],[31,2,32,3],[31,4,32,5],[31,6,32,7],[31,8,32,11],[31,14,31,16],[33,2,33,3],[33,6,33,7],[33,8,34,16],[34,1,34,5],[34,6,34,7],[25,1,33,1],[25,2,30,3],[25,6,30,7],[25,8,25,13],[25,14,25,16],[26,8,26,13],[26,14,26,16],[27,8,27,13],[27,14,27,16],[28,14,28,16],[29,8,29,13]]}
[]
[null,"Riparian Vegetation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[null,"Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,"Location:",{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""}]
[null,null,null,null,null,null,null,null,"Disturbed      (Impacted Reach)"]
[null,"Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,"Reference Reach",null,null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
[]
[null,"Existing Species Composition:",null,null,null,null,null,null,null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
[null,"Potential Species Composition:",null,null,null,null,null,null,null,null,null,"Date:",null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[null,"Riparian Cover Categories",null,null,"Percent Aerial Cover*",null,"Percent of Site Coverage**",null,"Species Composition",null,null,null,null,null,"Percent of Total Species Composition"]
[null,"1. Overstory","Canopy Layer"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,"2. Understory","Shrub Layer"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,"3. Ground Level","Herbaceous"]
[]
[]
[]
[]
[]
[null,null,"Leaf or Needle Litter",null,null,null,null,null,"Remarks:                                                             Condition, vigor and/or usage of existing reach:",null,null,null,null,null,1]
[]
[null,null,"Bare Ground"]
[null,"*Based on crown closure                                                              **Based on basal area to surface area",null,null,null,null,"Column Total = 100%"]

{"sheet":"WS 3-2","index":10,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,2,3,8],[3,9,3,10],[3,11,3,12],[0,0,1,13],[0,15,2,18],[2,2,2,8],[2,9,2,10],[2,11,2,12],[14,2,14,12],[4,2,4,8],[4,11,4,12],[5,1,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[9,2,9,12],[10,2,10,12],[11,2,11,12],[12,2,12,12],[21,2,21,12],[22,2,22,12],[15,2,15,12],[16,2,16,12],[17,2,17,12],[18,2,18,12],[19,2,19,12],[20,2,20,12]]}
["Flow Regime",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[]
[null,"Stream:",{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
[null,"Location:",{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
[null,"Observers:",{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,null,null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[null,"List ALL COMBINATIONS that APPLY……..…….?"]
[]
[]
[null,"General Category"]
[null,"E","Ephemeral stream channel:  Flows only in response to precipitation."]
[null,"S","Subterranean stream channel:  Flows parallel to and near the surface for various seasons  –  a sub-surface flow that follows the stream bed.  "]
[null,"I ","Intermittent stream channel:  Surface water flows discontinuously along its length. Often associated with sporadic or seasonal flows and also with Karst (limestone) geology where losing/gaining reaches create flows that disappear then reappear farther downstream."]
[null,"P","Perennial stream channels:  Surface water persists yearlong."]
[null,"Specific Category"]
[null,1,"Seasonal variation in streamflow dominated primarily by snowmelt runoff.  "]
[null,2,"Seasonal variation in streamflow dominated primarily by stormflow runoff.  "]
[null,3,"Uniform stage and associated streamflow due to spring-fed condition, backwater, etc.  "]
[null,4,"Streamflow regulated by glacial melt.  "]
[null,5,"Ice flows/ice torrents from ice dam breaches.  "]
[null,6,"Alternating flow/backwater due to tidal influence.  "]
[null,7,"Regulated streamflow due to diversions, dam release, dewatering, etc.  "]
[null,8,"Altered due to development, such as urban streams, cut-over watersheds, or vegetation conversions (forested to grassland) that change flow response to precipitation events.  "]
[null,9,"Rain-on-snow generated runoff."]

{"sheet":"WS 3-3","index":11,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[7,0,7,2],[0,0,1,3],[0,5,3,8],[2,1,2,3],[3,1,3,3],[6,0,6,3],[8,0,8,3],[9,0,11,0],[9,3,11,3],[26,0,28,3],[9,1,9,2],[10,1,10,2]]}
["Stream Size and Order",null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[]
["Stream:",{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""}]
["Location:",{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""}]
["Observers:",{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},"Stream Type:",{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["Landscape Type:",{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""},"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[]
["Stream Size Category and Order  ?"]
[]
["Category","STREAM SIZE:  ",null,"Check (ü) Appropriate Category"]
[null,"Bankfull Width"]
[null,"meters","feet"]
["S-1",0.30499999999999999,"<1"]
["S-2","0.3 – 1.5","1 – 5"]
["S-3","1.5 – 4.6","5 – 15"]
["S-4","4.6 – 9.0","15 – 30"]
["S-5","9.0 – 15.0","30 – 50"]
["S-6","15.0 – 22.8","50 – 75"]
["S-7","22.8 – 30.5","75 – 100"]
["S-8","30.5 – 46.0","100 – 150"]
["S-9","46 – 76","150 – 250"]
["S-10","76 – 107","250 – 350"]
["S-11","107 – 150","350 – 500"]
["S-12","150 – 305","500 – 1000"]
["S-13",">305",">1000"]
["Stream Order"]
["Add categories in parenthesis for specific stream order of reach.  For example, a third-order stream with a bankfull width of 6.1 meters (20 feet) would be indexed as: S-4(3). "]

{"sheet":"WS 3-4","index":12,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,1,10],[0,12,3,15],[2,0,2,1],[2,2,2,5],[2,6,2,7],[2,8,2,9],[3,0,3,1],[3,2,3,5],[3,6,3,7],[3,8,3,9],[9,1,9,9],[4,0,4,1],[4,2,4,5],[4,6,4,7],[4,8,4,9],[6,0,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9]]}
["Meander Patterns",null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,"Date:",null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[]
["List ALL CATEGORIES that APPLY  ?"]
[]
[]
[null,"Various Meander Pattern Variables modified from Galay et al. (1973)"]

{"sheet":"WS 3-5","index":13,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,1,10],[0,12,3,15],[2,0,2,1],[2,2,2,5],[2,6,2,7],[2,8,2,9],[3,0,3,1],[3,2,3,5],[3,6,3,7],[3,8,3,9],[9,1,9,9],[4,0,4,1],[4,2,4,5],[4,6,4,7],[4,8,4,9],[6,0,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9]]}
["Depositional Patterns",null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,"Date:",null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[]
["List ALL CATEGORIES that APPLY  ?"]
[]
[]
[null,"Various Depositional Features modified from Galay et al. (1973)"]

{"sheet":"WS 3-6","index":14,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,12],[0,14,2,17],[1,0,1,1],[1,2,1,7],[1,8,1,9],[1,10,1,12],[2,0,2,1],[2,2,2,7],[2,8,2,9],[2,10,2,12],[3,0,3,1],[3,2,3,7],[3,8,3,9],[3,10,3,12],[4,0,4,2],[4,3,4,11],[5,1,5,2],[5,3,5,11],[6,1,6,2],[6,3,6,11],[7,1,7,2],[7,3,7,11],[8,1,8,2],[8,3,8,11],[9,1,9,2],[9,3,9,11],[10,1,10,2],[10,3,10,11],[14,1,14,2],[14,3,14,11],[11,1,11,2],[11,3,11,11],[12,1,12,2],[12,3,12,11],[13,1,13,2],[13,3,13,11]]}
["Channel Blockages",null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,null,"Date:",null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
["Description/Extent",null,null,"Materials that upon placement into the active channel or flood-prone area may cause adjustments in channel dimensions or conditions due to influences on the existing flow regime.  ",null,null,null,null,null,null,null,null,"Check (ü) all that apply"]
["D1","None",null,"Minor amounts of small, floatable material.  "]
["D2","Infrequent",null,"Debris consists of small, easily moved, floatable material, e.g., leaves, needles, small limbs, and twigs."]
["D3","Moderate",null,"Increasing frequency of small- to medium-sized material, such as large limbs, branches, and small logs, that when accumulated affect 10% or less of the active channel cross-sectional area.  "]
["D4","Numerous",null,"Significant build-up of medium- to large-sized materials, e.g., large limbs, branches, small logs, or portions of trees, occupying 10–30% of the active channel cross-sectional area.  "]
["D5","Extensive",null,"Debris \"dams\" of predominantly larger materials, e.g., branches, logs, and trees, occupying 30–50% of the active channel cross-sectional area, often extending across the width of the active channel.  "]
["D6","Dominating",null,"Large, somewhat continuous, debris \"dams,\" extensive in nature and occupying over 50% of the active channel cross-sectional area. Such accumulations may divert water into the flood-prone areas and form fish migration barriers, even when flows are at less than bankfull."]
["D7","Beaver Dams:  Few",null,"An infrequent number of dams spaced such that normal streamflow and expected channel conditions exist in the reaches between dams.  "]
["D8","Beaver Dams:  Frequent",null,"Frequency of dams is such that backwater conditions exist for channel reaches between structures where streamflow velocities are reduced and channel dimensions or conditions are influenced.  "]
["D9","Beaver Dams:  Abandoned",null,"Numerous abandoned dams, many of which have filled with sediment or breached, initiating a series of channel adjustments, such as streambank erosion, lateral migration, avulsion, aggradation, or degradation.  "]
["D10","Human Influences",null,"Structures, facilities, or materials related to land uses or development located within the flood-prone area, such as diversions or low-head dams, controlled by-pass channels, velocity control structures, and various transportation encroachments that have an influence on the existing flow regime, such that significant channel adjustments occur. "]

{"sheet":"WS 3-7","index":15,"n_rows":9,"n_cols":30,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,12],[0,14,2,14],[1,0,1,1],[1,2,1,7],[1,8,1,9],[1,10,1,12],[2,0,2,1],[2,2,2,7],[2,8,2,9],[2,10,2,12],[3,0,3,1],[3,2,3,7],[3,8,3,9],[3,10,3,12],[5,2,5,4],[5,7,5,10],[6,2,6,4],[6,7,6,11],[7,0,7,12],[8,0,8,8],[8,9,8,12]]}
["Degree of Channel Incision",null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab.",null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,null,"Date:",null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.1000000000000001]
[null,null,"Low Bank Height:",null,null,null,null,"Bank-Height Ratio (BHR):",null,null,null,{"$f":"IF(OR($F$6=\"\",$F$7=\"\"),\"\",$F$6/$F$7)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1.3]
[null,null,"Bankfull Max Depth:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,2]
["Degree of Channel Incision Stability Rating ?"]

{"sheet":"WS 3-8","index":16,"n_rows":10,"n_cols":35,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,12],[0,14,2,17],[1,0,1,1],[1,2,1,7],[1,8,1,9],[1,10,1,12],[2,0,2,1],[2,2,2,7],[2,8,2,9],[2,10,2,12],[3,0,3,1],[3,2,3,7],[3,8,3,9],[3,10,3,12],[5,0,5,4],[5,7,5,11],[6,0,6,4],[6,7,6,11],[7,0,7,12],[8,0,8,8],[8,9,8,12]]}
["Width/Depth Ratio State",null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,null,"Date:",null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[]
["Existing Width/Depth Ratio (W/d):",null,null,null,null,null,null,"Existing W/d to Reference W/dref :",null,null,null,null,{"$f":"IF(OR($F$6=\"\",$F$7=\"\"),\"\",$F$6/$F$7)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,1]
["Reference Width/Depth Ratio (W/dref):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.2,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1.4,0.6]
["Width/Depth Ratio State Stability Rating ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1.6,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,1.8,0.2]

{"sheet":"WS 3-9","index":17,"n_rows":9,"n_cols":43,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,12],[0,14,2,17],[1,0,1,1],[1,2,1,7],[1,8,1,9],[1,10,1,12],[2,0,2,1],[2,2,2,7],[2,8,2,9],[2,10,2,12],[3,0,3,1],[3,2,3,7],[3,8,3,9],[3,10,3,12],[5,0,5,5],[5,8,5,11],[6,0,6,5],[6,7,6,11],[7,0,7,12],[8,0,8,8],[8,9,8,12]]}
["Degree of Confinement",null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,"Unconfined"]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.8,"Moderately Unconfined"]
["Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.3,"Confined"]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,null,"Date:",null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0.1,"Severely Confined"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0]
["Existing Meander Width Ratio (MWR):",null,null,null,null,null,null,null,"Ratio of MWR to MWRref :",null,null,null,{"$f":"IF(OR($G$6=\"\",$G$7=\"\"),\"\",$G$6/$G$7)","v":""}]
["Reference Meander Width Ratio (MWRref):"]
[]
["Degree of Confinement Stability Rating ?"]

{"sheet":"WS 3-10","index":18,"n_rows":29,"n_cols":30,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,29,3,32],[3,10,3,14],[3,16,3,20],[3,22,3,26],[0,1,0,6],[0,9,0,12],[0,16,0,17],[0,20,0,24],[0,26,0,27],[3,4,3,8],[6,2,6,3],[6,4,6,8],[1,0,2,0],[1,1,2,1],[1,2,2,3],[3,0,6,0],[3,2,3,3],[4,10,4,14],[4,16,4,20],[4,22,4,26],[5,2,5,3],[5,4,5,8],[5,10,5,14],[5,16,5,20],[5,22,5,26],[4,2,4,3],[4,4,4,8],[6,10,6,14],[6,16,6,20],[6,22,6,26],[7,0,11,0],[7,2,7,3],[7,4,7,8],[7,10,7,14],[7,16,7,20],[7,22,7,26],[8,2,8,3],[8,4,8,8],[8,10,8,14],[8,16,8,20],[8,22,8,26],[9,2,9,3],[9,4,9,8],[9,10,9,14],[9,16,9,20],[9,22,9,26],[11,2,11,3],[11,4,11,8],[11,10,11,14],[11,16,11,20],[11,22,11,26],[10,2,10,3],[10,4,10,8],[10,10,10,14],[10,16,10,20],[10,22,10,26],[13,22,13,26],[14,2,14,3],[14,4,14,8],[14,10,14,14],[14,16,14,20],[14,22,14,26],[13,2,13,3],[13,4,13,8],[13,10,13,14],[13,16,13,20],[16,2,16,3],[16,4,16,8],[16,10,16,14],[16,16,16,20],[16,22,16,26],[15,2,15,3],[15,4,15,8],[15,10,15,14],[15,16,15,20],[15,22,15,26],[24,0,24,1],[24,25,25,26],[24,27,25,27],[17,2,17,3],[17,4,17,8],[17,10,17,14],[17,16,17,20],[17,22,17,26],[20,0,20,1],[20,25,21,26],[12,0,17,0],[12,2,12,3],[12,4,12,8],[12,10,12,14],[12,16,12,20],[12,22,12,26],[26,25,27,27],[28,13,29,24],[28,25,29,27],[20,27,21,27],[22,25,23,26],[22,27,23,27]]}
["Stream: ",{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,null,null,"Location:",{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,null,"Landscape Type:",{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""},null,null,"Observers:",{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""},null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Loca-tion","Key","Category",null,"Excellent",null,null,null,null,null,"Good",null,null,null,null,null,"Fair",null,null,null,null,null,"Poor"]
[null,null,null,null,"Description",null,null,null,null,"Rating","Description",null,null,null,null,"Rating","Description",null,null,null,null,"Rating","Description",null,null,null,null,"Rating"]
["Upper banks",1,"Landform slope",null,"Bank slope gradient <30%.",null,null,null,null,2,"Bank slope gradient 30–40%.",null,null,null,null,4,"Bank slope gradient 40–60%.",null,null,null,null,6,"Bank slope gradient > 60%.",null,null,null,null,8]
[null,2,"Mass erosion",null,"No evidence of past or future mass erosion.",null,null,null,null,3,"Infrequent. Mostly healed over. Low future potential.",null,null,null,null,6,"Frequent or large, causing sediment nearly yearlong.",null,null,null,null,9,"Frequent or large, causing sediment nearly yearlong OR imminent danger of same.",null,null,null,null,12]
[null,3,"Debris jam potential",null,"Essentially absent from immediate channel area.",null,null,null,null,2,"Present, but mostly small twigs and limbs.",null,null,null,null,4,"Moderate to heavy amounts, mostly larger sizes.",null,null,null,null,6,"Moderate to heavy amounts, predominantly larger sizes.",null,null,null,null,8]
[null,4,"Vegetative bank protection",null,"> 90% plant density. Vigor and variety suggest a deep, dense, soil-binding root mass.",null,null,null,null,3,"70–90% density. Fewer species or less vigor suggest less dense or deep root mass.",null,null,null,null,6,"50–70% density. Lower vigor and fewer species from a shallow, discontinuous root mass.",null,null,null,null,9,"<50% density plus fewer species and less vigor indicating poor, discontinuous, and shallow root mass.",null,null,null,null,12]
["Lower banks",5,"Channel capacity",null,"Bank heights sufficient to contain the bankfull stage. Width/depth ratio departure from reference width/depth ratio = 1.0. Bank-Height Ratio (BHR) = 1.0.",null,null,null,null,1,"Bankfull stage is contained within banks. Width/depth ratio departure from reference width/depth ratio = 1.0–1.2. Bank-Height Ratio (BHR) = 1.0–1.1.",null,null,null,null,2,"Bankfull stage is not contained. Width/depth ratio departure from reference width/depth ratio = 1.2–1.4. Bank-Height Ratio (BHR) = 1.1–1.3.",null,null,null,null,3,"Bankfull stage is not contained; over-bank flows are common with flows less than bankfull. Width/depth ratio departure from reference width/depth ratio > 1.4. Bank-Height Ratio (BHR) > 1.3.",null,null,null,null,4]
[null,6,"Bank rock content",null,"> 65% with large angular boulders. 12\"+ common.",null,null,null,null,2,"40–65%. Mostly boulders and small cobbles 6–12\".",null,null,null,null,4,"20–40%. Most in the 3–6\" diameter class.",null,null,null,null,6,"<20% rock fragments of gravel sizes, 1–3\" or less.",null,null,null,null,8]
[null,7,"Obstructions to flow",null,"Rocks and logs firmly imbedded. Flow pattern w/o cutting or deposition. Stable bed.",null,null,null,null,2,"Some present causing erosive cross currents and minor pool filling. Obstructions fewer and less firm.",null,null,null,null,4,"Moderately frequent, unstable obstructions move with high flows causing bank cutting and pool filling.",null,null,null,null,6,"Frequent obstructions and deflectors cause bank erosion yearlong. Sediment traps full, channel migration occurring.",null,null,null,null,8]
[null,8,"Cutting",null,"Little or none. Infrequent raw banks <6\".",null,null,null,null,4,"Some, intermittently at outcurves and constrictions. Raw banks may be up to 12\".",null,null,null,null,6,"Significant. Cuts 12–24\" high. Root mat overhangs and sloughing evident.",null,null,null,null,12,"Almost continuous cuts, some over 24\" high. Failure of overhangs frequent.",null,null,null,null,16]
[null,9,"Deposition",null,"Little or no enlargement of channel or point bars.",null,null,null,null,4,"Some new bar increase, mostly from coarse gravel.",null,null,null,null,8,"Moderate depostion of new gravel and coarse sand on old and some new bars.",null,null,null,null,12,"Extensive deposit of predominantly fine particles. Accelerated bar development.",null,null,null,null,16]
["Bottom",10,"Rock angularity",null,"Sharp edges and corners. Plane surfaces rough.",null,null,null,null,1,"Rounded corners and edges. Surfaces smooth and flat.",null,null,null,null,2,"Corners and edges well-rounded in two dimensions.",null,null,null,null,3,"Well-rounded in all dimensions, surfaces smooth.",null,null,null,null,4]
[null,11,"Brightness",null,"Surfaces dull, dark, or stained. Generally not bright.",null,null,null,null,1,"Mostly dull, but may have <35% bright surfaces.",null,null,null,null,2,"Mixture dull and bright, i.e., 35–65% mixture range.",null,null,null,null,3,"Predominantly bright, > 65%, exposed or scoured surfaces.",null,null,null,null,4]
[null,12,"Consolidation of particles",null,"Assorted sizes tightly packed or overlapping.",null,null,null,null,2,"Moderately packed with some overlapping.",null,null,null,null,4,"Mostly loose assortment with no apparent overlap.",null,null,null,null,6,"No packing evident. Loose assortment, easily moved.",null,null,null,null,8]
[null,13,"Bottom size distribution",null,"No size change evident. Stable material 80–100%.",null,null,null,null,4,"Distribution shift light. Stable material 50–80%.",null,null,null,null,8,"Moderate change in sizes. Stable materials 20–50%.",null,null,null,null,12,"Marked distribution change. Stable materials 0–20%.",null,null,null,null,16]
[null,14,"Scouring and deposition",null,"<5% of bottom affected by scour or deposition.",null,null,null,null,6,"5–30% affected. Scour at constrictions and where grades steepen. Some deposition in pools.",null,null,null,null,12,"30–50% affected. Deposits and scour at obstructions, constrictions, and bends. Some filling of pools.",null,null,null,null,18,"More than 50% of the bottom in a state of flux or change nearly yearlong.",null,null,null,null,24]
[null,15,"Aquatic vegetation",null,"Abundant growth moss-like, dark green perennial. In swift water too.",null,null,null,null,1,"Common. Algae forms in low velocity and pool areas. Moss here too.",null,null,null,null,2,"Present but spotty, mostly in backwater. Seasonal algae growth makes rocks slick.",null,null,null,null,3,"Perennial types scarce or absent. Yellow-green, short-term bloom may be present.",null,null,null,null,4]
[null,null,null,null,null,null,null,null,"Excellent Total =",null,null,null,null,null,"Good Total =",null,null,null,null,null,"Fair Total =",null,null,null,null,null,"Poor Total ="]
[]
["Stream type",null,"A1 ","A2","A3","A4","A5","A6","B1","B2","B3","B4","B5","B6","C1","C2","C3","C4","C5","C6","D3","D4","D5","D6",null,"Grand Total = "]
["Good (Stable)",null,"38-43","38-43","54-90","60-95","60-95","50-80","38-45","38-45","40-60","40-64","48-68","40-60","38-50","38-50","60-85","70-90","70-90","60-85","85-107","85-107","85-107","67-98"]
["Fair (Mod. unstable)",null,"44-47","44-47","91-129","96-132","96-142","81-110","46-58","46-58","61-78","65-84","69-88","61-78","51-61","51-61","86-105","91-110","91-110","86-105","108-132","108-132","108-132","99-125",null,"Existing Stream Type = "]
["Poor (Unstable)",null,"48+","48+","130+","133+","143+","111+","59+","59+","79+","85+","89+","79+","62+","62+","106+","111+","111+","106+","133+","133+","133+","126+"]
["Stream type",null,"DA3","DA4","DA5","DA6","E3","E4","E5","E6","F1","F2","F3","F4","F5","F6","G1","G2","G3","G4","G5","G6",null,null,null,"*Potential Stream Type ="]
["Good (Stable)",null,"40-63","40-63","40-63","40-63","40-63","50-75","50-75","40-63","60-85","60-85","85-110","85-110","90-115","80-95","40-60","40-60","85-107","85-107","90-112","85-107"]
["Fair (Mod. unstable)",null,"64-86","64-86","64-86","64-86","64-86","76-96","76-96","64-86","86-105","86-105","111-125","111-125","116-130","96-110","61-78","61-78","108-120","108-120","113-125","108-120",null,null,null,"Modified channel stability rating = "]
["Poor (Unstable)",null,"87+","87+","87+","87+","87+","97+","97+","87+","106+","106+","126+","126+","131+","111+","79+","79+","121+","121+","126+","121+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"*Rating is adjusted to potential stream type, not existing stream type"]

{"sheet":"WS 3-11","index":19,"n_rows":39,"n_cols":25,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,12],[0,24,2,27],[1,2,1,5],[1,6,1,7],[1,8,1,12],[2,2,2,5],[2,6,2,7],[2,8,2,12],[5,11,7,11],[8,4,8,9],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,11,3,12],[4,3,4,9],[4,10,4,12],[5,4,7,4],[5,6,7,7],[5,8,7,8],[5,9,7,9],[9,4,11,4],[9,6,11,7],[9,8,11,8],[9,9,11,9],[9,11,11,11],[13,6,14,7],[13,9,14,9],[13,11,14,11],[15,3,15,9],[12,5,12,9],[16,9,18,9],[22,1,22,6],[16,11,18,11],[17,13,18,17],[19,7,19,9],[19,13,20,17],[20,9,22,9],[20,11,22,11],[21,13,22,17],[29,1,30,6],[38,14,40,23],[27,8,27,9],[28,11,30,11],[29,13,30,18],[32,8,32,9],[33,11,34,11],[33,14,33,15],[34,8,34,9],[34,14,36,15],[23,13,24,17],[24,8,24,9],[24,11,26,11],[26,1,27,6],[28,1,28,6],[25,8,25,9],[23,1,23,6],[24,1,24,6],[25,1,25,6]]}
["Bank Erosion Hazard Index (BEHI)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[null,"Stream:",{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,"Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""}]
[null,"Station:",null,null,null,null,"Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""}]
[null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""},null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""},null,"Landscape Type:",null,null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
[null,null,null,"Study Bank Height to Bankfull Height ( C )",null,null,null,null,null,null,"BEHI Score (Fig. 3-7)"]
[null,null,null,"Study ",null,"Bankfull",null,null,"( A ) / ( B ) = ",{"$f":"IF(OR($G$6=\"\",$E$6=\"\"),\"\",$E$6/$G$6)","v":""}]
[null,null,null,"Bank",null,"Height"]
[null,null,null,"Height (ft) =",null," (ft) ="]
[null,null,null,null,"             Root Depth to Study Bank Height ( E )"]
[null,null,null,"Root ",null,"Study ",{"$f":"IF(OR($E$6=\"\"),\"\",$E$6)","v":""},null,"( D ) / ( A ) = ",{"$f":"IF(OR($E$6=\"\",$E$10=\"\"),\"\",$E$10/$E$6)","v":""}]
[null,null,null,"Depth",null,"Bank"]
[null,null,null,"(ft) =",null,"Height (ft) ="]
[null,null,null,null,null,"  Weighted Root Density ( G )"]
[null,null,null,null,null,"Root Density",null,null,"( F ) x ( E )  = ",{"$f":"IF(OR($J$10=\"\",$G$14=\"\"),\"\",$G$14*$J$10)","v":""}]
[null,null,null,null,null,"as % = "]
[null,null,null,"                                                                Bank Angle ( H )"]
[null,null,null,null,null,null,null,null,"Bank"]
[null,null,null,null,null,null,null,null,"Angle"]
[null,null,null,null,null,null,null,null,"  as Degrees  =  "]
[null,null,null,null,null,null,null,"Surface Protection ( I )"]
[null,null,null,null,null,null,null,null,"Surface"]
[null,null,null,null,null,null,null,null,"Protection"]
[null,"Bank Material Adjustment:",null,null,null,null,null,null,"      as %      = "]
[null,"Bedrock (Overall Very Low BEHI)"]
[null,"Boulders (Overall Low BEHI)",null,null,null,null,null,null,"     Bank Material"]
[null,"Cobble (Subtract 10 points if uniform medium to large cobble)",null,null,null,null,null,null,"                Adjustment"]
[null,"Gravel or Composite Matrix (Add 5–10 points depending on percentage of bank material that is composed of sand)"]
[null,null,null,null,null,null,null,null,"Stratification Adjustment"]
[null,"Sand (Add 10 points)"]
[null,"Silt/Clay (Add 10 points if uniform silt; No adjustment if silt with a mixture of clay; Subtract 10 points if silt/clay mixture with high % of clay; Subtract 20 points if clay)"]
[]
[]
[null,"Very Low","Low","Moderate","High","Very High","Extreme",null," Adjective Rating"]
[null,null,null,null,null,null,null,null,null,"and",null,{"$f":"IF(OR(L6=\"\",L10=\"\", L14=\"\",L17=\"\",L21=\"\"),\"\",SUM(L6,L10,L14,L17,L21,L25,L29))","v":""}]
[null,"5 – 9.5","10 – 19.5","20 – 29.5","30 – 39.5","40 – 45","46 – 50",null,"                Total Score"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 3-7.  Streambank erodibility criteria showing conversion of measured ratios and bank variables to a BEHI rating (Rosgen, 1996, 2001b, 2006b).  Use Worksheet 3-11 to determine BEHI score."]

{"sheet":"WS 3-12","index":20,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[38,2,38,3],[36,2,37,3],[32,6,33,6],[32,5,33,5],[32,3,33,3],[31,4,33,4],[7,0,7,6],[7,8,7,9],[0,0,0,9],[0,11,3,14],[1,1,1,4],[1,6,1,9],[2,1,2,3],[3,2,3,7],[4,0,4,9],[5,0,5,6],[5,8,5,9],[6,0,6,6],[6,8,6,9],[8,0,8,6],[8,8,8,9],[9,0,9,6],[9,8,9,9],[10,0,10,6],[10,8,10,9],[11,0,11,6],[11,8,11,9],[12,0,14,0],[12,1,14,1],[12,2,12,6],[12,7,12,9],[13,2,13,7],[13,8,13,9],[14,2,14,7],[14,8,14,9],[23,1,26,1],[23,5,25,5],[15,0,26,0],[15,1,18,1],[23,2,24,2],[23,3,24,3],[23,4,24,4],[15,5,17,5],[19,1,22,1],[19,5,21,5],[15,3,16,3],[19,3,20,3],[15,2,16,2],[19,2,20,2],[27,3,28,3],[27,2,28,2],[32,2,33,2],[20,7,20,8],[21,7,21,8],[22,7,22,8],[31,8,33,8],[31,7,33,7],[27,0,35,0],[27,1,30,1],[46,0,46,2],[41,0,41,9],[42,0,43,2],[42,3,42,9],[44,0,44,2],[45,0,45,2],[31,9,34,9],[36,0,39,0],[36,1,39,1],[36,4,38,4],[39,2,39,3],[27,5,29,5],[31,1,35,1],[27,4,28,4],[47,0,47,2],[48,0,48,2],[49,0,49,2],[50,3,50,7],[50,8,50,9]]}
["Estimating Near-Bank Stress ( NBS )",null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Stream:                       ",{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,"Location:",{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""}]
["Station:",null,null,null,null,"Stream Type:",{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""},null,"Landscape Type:",{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Observers: ",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
["Methods for Estimating Near-Bank Stress (NBS)"]
["(1)   Channel pattern, transverse bar, or central bar creating NBS",null,null,null,null,null,null,"Level  I","Reconaissance"]
["(2)   Radius of curvature to bankfull width ( Rc / Wbkf )",null,null,null,null,null,null,"Level  II","General Prediction"]
["(3)   Pool slope to average water surface slope ( Sp / S )",null,null,null,null,null,null,"Level  II","General Prediction"]
["(4)   Pool slope to riffle slope ( Sp / Srif )",null,null,null,null,null,null,"Level  II","General Prediction"]
["(5)   Near-bank maximum depth to bankfull mean depth ( dnb / dbkf )",null,null,null,null,null,null,"Level  III","Detailed Prediction"]
["(6)   Near-bank shear stress to bankfull shear stress ( tnb / tbkf )",null,null,null,null,null,null,"Level  III","Detailed Prediction"]
["(7)   Velocity profiles / Isovels / Velocity gradient",null,null,null,null,null,null,"Level  IV","Validation"]
["Level I",-1,"Transverse or central bars - short or discontinuous……...……….…",null,null,null,null,"…………………...….NBS = High / Very High"]
[null,null,"Extensive deposition (continuous, cross-channel)……………..……………...…….",null,null,null,null,null,"………………....NBS = Extreme"]
[null,null,"Chute cutoffs, down-valley meander migration, converging flow……………………",null,null,null,null,null,"………………….….NBS = Extreme"]
["Level II",-2,"Radius of   Curvature      ","Bankfull Width ",null,"Near-Bank Stress (NBS)"]
[null,null,null,null,"Ratio "]
[null,null,"Rc (ft)","Wbkf (ft)","Rc / Wbkf"]
[]
[null,-3,"Pool Slope ","Average Slope ",null,"Near-Bank Stress (NBS)"]
[null,null,null,null,"Ratio ",null,null,"Dominant"]
[null,null,"Sp","S","Sp / S",null,null,"Near-Bank Stress"]
[]
[null,-4,"Pool Slope ","Riffle Slope ","Ratio ","Near-Bank Stress (NBS)"]
[]
[null,null,"Sp","Srif","Sp / Srif"]
[]
["Level III",-5,"Near-Bank Max Depth ","Mean Depth ","Ratio ","Near-Bank Stress (NBS)"]
[]
[null,null,"dnb (ft)","dbkf (ft)","dnb / dbkf"]
[]
[null,-6,null,null,"Near-Bank Shear Stress ",null,null,"Bankfull Shear Stress ","Ratio","Near-Bank Stress (NBS)"]
[null,null,"Near-Bank Max Depth ","Near-Bank Slope ",null,"Mean Depth ","Average Slope "]
[]
[null,null,"dnb (ft)","Snb","tnb ( lb/ft2 )","dbkf (ft)","S","tbkf (lb/ft2)"," tnb / tbkf"]
[]
["Level IV",-7,"Velocity Gradient ",null,"Near-Bank Stress (NBS)"]
[]
[null,null,"( ft / sec / ft )"]
[]
[]
["Converting Values to a Near-Bank Stress (NBS) Rating"]
["Near-Bank Stress (NBS) Ratings",null,null,"Method Number"]
[null,null,null,-1,-2,-3,-4,-5,-6,-7]
["Very Low",null,null," N / A","> 3.00","< 0.20","< 0.40","< 1.00","< 0.80","< 0.50"]
["Low",null,null," N / A","2.21 – 3.00","0.20 – 0.40","0.41 – 0.60","1.00 – 1.50","0.80 – 1.05","0.50 – 1.00"]
["Moderate",null,null," N / A","2.01 – 2.20","0.41 – 0.60","0.61 – 0.80","1.51 – 1.80","1.06 – 1.14","1.01 – 1.60"]
["High",null,null,"See","1.81 – 2.00","0.61 – 0.80","0.81 – 1.00","1.81 – 2.50","1.15 – 1.19","1.61 – 2.00"]
["Very High",null,null,-1,"1.50 – 1.80","0.81 – 1.00","1.01 – 1.20","2.51 – 3.00","1.20 – 1.60","2.01 – 2.40"]
["Extreme",null,null,"Above","< 1.50","> 1.00","> 1.20","> 3.00","> 1.60","> 2.40"]
[null,null,null,"Overall Near-Bank Stress (NBS) Rating"]

{"sheet":"WS 3-13","index":21,"n_rows":27,"n_cols":25,"rows_kept":27,"cut":false,"hidden":false,"merged":[[24,8,25,8],[24,7,25,7],[22,0,22,6],[24,0,24,6],[3,5,3,6],[22,7,23,7],[22,8,23,8],[13,1,13,2],[15,1,15,2],[16,1,16,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[3,2,3,4],[6,1,6,2],[7,1,7,2],[4,0,4,2],[5,0,5,2],[0,0,0,9],[0,11,2,14],[1,2,1,5],[1,7,1,9],[2,0,2,1],[2,5,2,6],[2,2,2,4],[21,15,21,22],[21,24,21,31],[20,1,20,2],[21,0,21,6],[14,1,14,2],[26,0,26,6],[17,1,17,2],[18,1,18,2],[19,1,19,2],[23,0,23,6],[25,0,25,6]]}
["Streambank Erosion Prediction",null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,"Location:",{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""}]
["Graph Used:",null,null,null,null,"Total Stream Length (ft):",null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""},"Stream Type:",{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["(1)",null,null,"(2)","(3)","(4)","(5)","(6)","(7)","(8)"]
["Station (ft)",null,null,"BEHI Rating (Worksheet 3-11) (adjective)","NBS Rating (Worksheet 3-12) (adjective)","Bank Erosion Rate (Figure 3-9 or 3-10) (ft/yr)","Length of Bank (ft)","Study Bank Height (ft)","Erosion Subtotal [(4)×(5)×(6)] (ft3/yr)","Unit Erosion Rate (tons/yr/ft) {[(7)/27] × 1.3 / (5)}"]
["1.",null,null,null,null,null,null,null,{"$f":"IF(OR(F7=\"\",G7=\"\",H7=\"\"),\"\",F7*G7*H7)","v":""},{"$f":"IF(OR(I7=\"\",G7=\"\"),\"\",I7/27*1.3/G7)","v":""}]
["2.",null,null,null,null,null,null,null,{"$f":"IF(OR(F8=\"\",G8=\"\",H8=\"\"),\"\",F8*G8*H8)","v":""},{"$f":"IF(OR(I8=\"\",G8=\"\"),\"\",I8/27*1.3/G8)","v":""}]
["3.",null,null,null,null,null,null,null,"",""]
["4.",null,null,null,null,null,null,null,"",""]
["5.",null,null,null,null,null,null,null,"",""]
["6.",null,null,null,null,null,null,null,"",""]
["7.",null,null,null,null,null,null,null,"",""]
["8.",null,null,null,null,null,null,null,"",""]
["9.",null,null,null,null,null,null,null,"",""]
["10.",null,null,null,null,null,null,null,"",""]
["11.",null,null,null,null,null,null,null,"",""]
["12.",null,null,null,null,null,null,null,"",""]
["13.",null,null,null,null,null,null,null,"",""]
["14.",null,null,null,null,null,null,null,"",""]
["15.",null,null,null,null,null,null,null,"",""]
["Sum erosion subtotals in Column (7) for each BEHI/NBS combination",null,null,null,null,null,null,"Total Erosion (ft3/yr)",{"$f":"IF(OR(I7=\"\"),\"\",SUM(I7:I21))","v":""},"",null,null,null,null,null,"Figure 3-9.  Relationship of BEHI and NBS to predict annual streambank erosion rates from Colorado data (1989) for streams found in sedimentary and/or metamorphic geology (Rosgen, 1996, 2001b, 2006b).",null,null,null,null,null,null,null,null,"Figure 3-10.  Relationship of BEHI and NBS to predict annual streambank erosion rates from Yellowstone National Park data (1989) for streams found in alpine glaciation and/or volcanism geology (Rosgen, 1996, 2001b, 2006b)."]
["Convert erosion in ft3/yr to yds3/yr  ",null,null,null,null,null,null,"Total Erosion (yds3/yr)",{"$f":"IF(OR(I22=\"\"),\"\",I22/27)","v":""},""]
["{divide Total Erosion (ft3/yr) by 27}"]
["Convert erosion in yds3/yr to tons/yr ",null,null,null,null,null,null,"Total Erosion   (tons/yr)",{"$f":"IF(OR(I23=\"\"),\"\",I23*1.3)","v":""}]
[" {multiply Total Erosion (yds3/yr) by 1.3}"]
["Calculate erosion per unit length of channel  {divide Total Erosion (tons/yr) by Total Stream Length (ft) surveyed}",null,null,null,null,null,null,"Unit Erosion Rate (tons/yr/ft)",{"$f":"IF(OR(I25=\"\",G3=\"\"),\"\",I25/G3)","v":""}]

{"sheet":"WS 3-14","index":22,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,1,0,10],[0,13,3,16],[1,1,1,2],[1,3,1,6],[1,7,1,8],[1,9,1,10],[2,1,2,2],[2,3,2,6],[2,7,2,8],[2,9,2,10],[3,1,3,2],[3,3,3,7],[3,9,3,10],[4,1,4,10],[5,1,5,2],[5,4,5,10],[13,1,13,2],[6,1,6,2],[6,4,6,10],[7,1,7,2],[7,4,7,7],[8,1,8,2],[8,4,8,10],[9,1,9,2],[9,4,9,10],[10,1,10,2],[10,4,10,10],[12,1,12,10],[25,3,26,10],[14,1,14,2],[15,1,15,2],[15,8,15,9],[17,1,17,10],[18,1,18,2],[19,1,19,10],[20,1,20,2],[21,6,21,7],[23,1,23,10],[24,1,24,2],[24,3,24,10],[27,3,28,10],[29,3,30,10],[31,3,32,10],[32,13,33,21],[33,6,33,7]]}
[null,"Sediment Competence using Dimensional and Dimensionless Shear Stress Methods",null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[null,"Stream:  ",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
[null,"Location:  ",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
[null,"Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[null,"Enter Required Information for Existing Condition"]
[null,null,null,"D50","Median particle size of riffle bed material (mm)"]
[null,null,null,"D50","Median particle size of bar or sub-pavement sample (mm)"]
[null,{"$f":"IF(OR(I8=\"\"),\"\",I8/304.8)","v":""},null,"Dmax","Largest particle from bar sample (ft)",null,null,null,null,"(mm)","304.8 mm/ft"]
[null,null,null,"S","Existing average water surface slope (ft/ft)"]
[null,null,null,"d","Existing bankfull mean depth (ft)"]
[null,1.65,null,"gs-g/g","Immersed specific gravity of sediment"]
[]
[null,"Select the Appropriate Equation and Calculate Critical Dimensionless Shear Stress"]
[null,{"$f":"IF(OR(B6=\"\",B7=\"\"),\"\",B6/B7)","v":""},null,null,"Range:  3 – 7",null," Use EQUATION 1:",null,"t* = 0.0834 (                ) –0.872"]
[null,{"$f":"IF(OR(I8=\"\",B6=\"\"),\"\",I8/B6)","v":""},null,"Dmax/D50 ","Range:  1.3 – 3.0",null," Use EQUATION 2:",null,"t* = 0.0384 (Dmax/D50) –0.887"]
[null,{"$f":"IF(OR(B14=\"\",B15=\"\"),\"\",IF(AND(B14>2.9999,B14<7.01),0.0834*B14^(-0.872),IF(AND(B15>1.2999,B15<3.01),0.0384*B15^(-0.887),\"N/A\")))","v":""},null,"t*","Bankfull Dimensionless Shear Stress",null,null,null,"EQUATION USED:",null,{"$f":"IF(B16=\"\",\"\",IF(B16=0.0834*B14^(-0.872),\"1\",IF(B16=0.0384*B15^(-0.887),\"2\",IF(B16=\"N/A\",\"N/A\",\"\"))))","v":""}]
[]
[null,"Calculate Bankfull Mean Depth Required for Entrainment of Largest Particle in Bar Sample"]
[null,{"$f":"IF(OR(B8=\"\",B9=\"\",B16=\"\"),\"\",IF(B16=\"N/A\",\"N/A\",B16*B11*B8/B9))","v":""},null,"d","Required bankfull mean depth (ft)                                            ",null,null,null,null,null," (use Dmax in ft)"]
[null,"Calculate Average Water Surface Slope Required for Entrainment of Largest Particle in Bar Sample"]
[null,{"$f":"IF(OR(B16=\"\",B8=\"\",B10=\"\"),\"\",IF(B16=\"N/A\",\"N/A\",B16*B11*B8/B10))","v":""},null,"S","Required average water surface slope (ft/ft)",null,null,null,null,null,"(use Dmax in ft)"]
[null,null,null,"Check:","Stable ","Aggrading ","Degrading "]
[]
[null,"Sediment Competence Using Dimensional Shear Stress"]
[null,{"$f":"IF(OR(B10=\"\",B9=\"\"),\"\",62.4*B10*B9)","v":""},null,"Bankfull shear stress t = gdS (lbs/ft2) (substitute hydraulic radius, R, with mean depth, d )     g = 62.43, d = existing depth, S = existing slope"]
[null,"Shields","CO","Predicted largest moveable particle size (mm) at bankfull shear stress t (Figure 3-11)"]
[null,{"$f":"IF(B25=\"\",\"\",77.966*B25^1.042)","v":""},{"$f":"IF(B25=\"\",\"\",152.02*B25^0.7355)","v":""}]
[null,"Shields","CO","Predicted shear stress required to initiate movement of measured Dmax (mm) (Figure 3-11)"]
[null,{"$f":"IF(OR(B25=\"\",I8=\"\"),\"\",(I8/77.966)^(1/1.042))","v":""},{"$f":"IF(OR(B25=\"\",I8=\"\"),\"\",(I8/152.02)^(1/0.7355))","v":""}]
[null,"Shields","CO","Predicted mean depth required to initiate movement of measured Dmax (mm)                                                     t = predicted shear stress, g = 62.43, S = existing slope"]
[null,{"$f":"IF(OR(B29=\"\",B9=\"\"),\"\",B29/(62.4*B9))","v":""},{"$f":"IF(OR(C29=\"\",B9=\"\"),\"\",C29/(62.4*B9))","v":""}]
[null,"Shields","CO","Predicted slope required to initiate movement of measured Dmax (mm)                                                t = predicted shear stress, g = 62.43, d = existing depth"]
[null,{"$f":"IF(OR(B29=\"\",B10=\"\"),\"\",B29/(62.4*B10))","v":""},{"$f":"IF(OR(C29=\"\",B10=\"\"),\"\",C29/(62.4*B10))","v":""},null,null,null,null,null,null,null,null,null,null,"Figure 3-11.  Critical shear stress required to initiate movement of bed-material grains following the Shields relation (Leopold et al., 1964), as modified by field data from Colorado (Rosgen, 2006b; Rosgen and Silvey, 2007)."]
[null,null,null,"Check:","Stable ","Aggrading ","Degrading "]

{"sheet":"WS 3-15","index":23,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,0,9,1],[9,2,9,3],[0,0,0,3],[4,0,4,1],[4,2,4,3],[5,0,5,1],[5,2,6,3],[6,0,6,1],[0,5,2,8],[7,0,7,1],[7,2,7,3],[8,0,8,1],[8,2,8,3]]}
["Stream Succession Stage Shifts",null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Stream:",{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},"Stream Type:",{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["Location:",{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},"Landscape Type:",{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Observers:",{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
["Stream Type Stage Shifts (Figure 3-14)",null,"Stability Rating (Check ü Appropriate Rating)"]
["Stream Type at Potential, (C→E),",null,"  Stable"]
["(Fb→B), (F→Bc), (F→C), (G→B), (D→C)"]
["(E→C), (B→High W/d B), (C→High W/d C)",null,"  Moderately Unstable"]
["(Gc→F), (G→Fb), (F→D), (C→F)",null,"  Unstable"]
["(C→D), (A→G), (B→G), (D→G), (C→G), (E→G), (E→A)",null,"  Highly Unstable"]

{"sheet":"WS 3-16","index":24,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,15],[0,17,2,20],[1,2,1,9],[1,10,1,12],[1,13,1,15],[2,13,2,15],[2,9,2,12],[2,2,2,8],[3,10,3,12],[3,13,3,15],[4,0,6,2],[4,3,4,13],[4,15,6,15],[5,3,6,5],[5,6,6,8],[5,9,6,11],[5,12,6,14],[3,2,3,8],[7,0,8,0],[7,1,8,2],[7,3,7,5],[7,6,7,8],[7,9,7,11],[9,0,10,0],[9,1,10,2],[9,3,9,5],[9,6,9,8],[9,9,9,11],[7,15,8,15],[8,3,8,4],[8,6,8,7],[8,9,8,10],[8,12,8,13],[7,12,7,14],[9,12,9,14],[9,15,10,15],[10,3,10,4],[10,6,10,7],[10,9,10,10],[10,12,10,13],[11,15,12,15],[12,3,12,4],[12,9,12,10],[13,0,14,0],[13,1,14,2],[13,3,13,5],[13,6,13,8],[13,9,13,11],[13,12,13,14],[13,15,14,15],[11,0,12,0],[11,1,12,2],[11,3,11,5],[11,6,12,8],[11,9,11,11],[11,12,12,14],[15,0,16,0],[15,1,16,2],[15,3,15,5],[15,6,15,8],[15,9,15,11],[17,12,17,14],[14,3,14,4],[14,6,14,7],[14,9,14,10],[14,12,14,13],[15,12,15,14],[15,15,16,15],[16,3,16,4],[16,6,16,7],[16,9,16,10],[16,12,16,13],[18,0,18,2],[18,3,18,14],[18,15,21,15],[19,0,21,2],[19,3,19,5],[19,6,19,8],[19,9,19,11],[19,12,19,14],[20,3,20,5],[20,6,20,8],[20,9,20,11],[20,12,20,14],[21,3,21,5],[21,6,21,8],[21,9,21,11],[21,12,21,14]]}
["Lateral Stability Prediction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,null,null,null,"Stream Type:",null,null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,null,null,"Landscape Type:",null,null,null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,null,null,null,"Date:",null,null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
["Lateral stability criteria (choose one stability category for each criterion 1–5)",null,null,"Lateral Stability Categories",null,null,null,null,null,null,null,null,null,null,null,"Selected Points (from each row)"]
[null,null,null,"Stable",null,null,"Moderately Unstable",null,null,"Unstable",null,null,"Highly Unstable"]
[]
[1,"W/d Ratio State (Worksheet 3-8)",null,"< 1.2",null,null,"1.2 – 1.4",null,null,"1.4 – 1.6",null,null,"> 1.6"]
[null,null,null,null,null,"(2)",null,null,"(4)",null,null,"(6)",null,null,"(8)"]
[2,"Depositional Patterns (Worksheet 3-5)",null,"B1, B2",null,null,"B4, B8",null,null,"B3",null,null,"B5, B6, B7"]
[null,null,null,null,null,"(1)",null,null,"(2)",null,null,"(3)",null,null,"(4)"]
[3,"Meander Patterns (Worksheet 3-4)",null,"M1, M3, M4",null,null,null,null,null,"M2, M5, M6, M7, M8"]
[null,null,null,null,null,"(1)",null,null,null,null,null,"(3)"]
[4,"Streambank Erosion:  Unit Rate                        (Worksheet 3-13)",null,"< 0.006",null,null,"0.006 – 0.04",null,null,"0.041 – 0.07",null,null,"> 0.07"]
[null,null,null,null,null,"(2)",null,null,"(4)",null,null,"(6)",null,null,"(8)"]
[5,"Degree of Confinement (MWR / MWRref) (Worksheet 3-9)",null,"> 0.8",null,null,"0.3 – 0.79",null,null,"0.1 – 0.29",null,null,"< 0.1"]
[null,null,null,null,null,"(1)",null,null,"(2)",null,null,"(3)",null,null,"(4)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Points",null,null,{"$f":"IF(OR(P8=\"\",P10=\"\",P12=\"\",P14=\"\",P16=\"\"),\"\",SUM(P8:P17))","v":""}]
[null,null,null,"Lateral Stability Category Point Range"]
["Overall Lateral Stability Category (use total points and check ü stability rating)",null,null,"Stable",null,null,"Moderately Unstable",null,null,"Unstable",null,null,"Highly     Unstable"]
[null,null,null,"< 10",null,null,"10 – 12",null,null,"13 – 21 ",null,null,"> 21 "]

{"sheet":"WS 3-17","index":25,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,11],[0,13,2,16],[1,2,1,6],[1,7,1,8],[1,9,1,11],[2,0,2,1],[2,2,2,6],[2,7,2,8],[2,9,2,11],[3,0,3,1],[3,2,3,6],[3,7,3,8],[3,9,3,11],[4,0,5,2],[4,3,4,10],[4,11,5,11],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,12,5,17],[6,0,7,0],[6,1,7,2],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,7,11],[12,9,12,10],[8,11,9,11],[10,0,11,0],[10,1,11,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,11,11],[8,0,9,0],[8,1,9,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[16,5,16,6],[16,7,16,8],[16,9,16,10],[12,11,13,11],[14,0,15,0],[14,1,15,2],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,15,11],[12,0,13,0],[12,1,13,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[21,5,21,6],[21,7,21,8],[21,9,21,10],[16,11,17,11],[18,0,19,2],[18,9,18,10],[19,3,19,10],[20,0,21,2],[20,3,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[21,3,21,4],[16,0,17,0],[16,1,17,2],[16,3,16,4]]}
["Vertical Stability Prediction for Excess Deposition and Aggradation",null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,"Date:",null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
["Vertical Stability Criteria (choose one stability category for each criterion 1–6)",null,null,"Vertical Stability Categories for Excess Deposition / Aggradation",null,null,null,null,null,null,null,"Selected Points          (from each row)"]
[null,null,null,"No Deposition",null,"Moderate Deposition",null,"Excess Deposition",null,"Aggradation"]
[1,"Sediment Competence (Worksheet 3-14)",null,"Sufficient depth and slope to transport largest size available",null,"Trend toward insufficient depth or slope- slightly incompetent",null,"Cannot move D35 of bed material and/or D100 of bar material",null,"Cannot move D16 of bed material and/or D100 of bar or sub-pavement size"]
[null,null,null,null,"(2)",null,"(4)",null,"(6)",null,"(8)"]
[2,"Sediment Capacity (POWERSED)",null,"Sufficient capacity to transport annual load",null,"Trend toward insufficient sediment capacity",null,"Reduction up to 25% of annual sediment yield of bedload or suspended sand ",null,"Reduction over 25% of annual sediment yield for bedload or suspended sand"]
[null,null,null,null,"(2)",null,"(4)",null,"(6)",null,"(8)"]
[3,"W/d Ratio State (Worksheet 3-8)",null,"< 1.2",null,"1.2 – 1.4",null,"1.4 – 1.6",null,"> 1.6"]
[null,null,null,null,"(2)",null,"(4)",null,"(6)",null,"(8)"]
[4,"Stream Succession Stage Shifts (Worksheet 3-15)",null,"Current stream type at potential or does not indicate deposition/ aggradation",null,"(E→C)",null,"(B→High W/d B), (C→High W/d C),  (C→F), (Gc→F), (G→Fb)",null,"(C→D), (F→D)"]
[null,null,null,null,"(2)",null,"(4)",null,"(6)",null,"(8)"]
[5,"Depositional Patterns (Worksheet 3-5)",null,"B1",null,"B2, B4",null,"B3, B5",null,"B6, B7, B8"]
[null,null,null,null,"(1)",null,"(2)",null,"(3)",null,"(4)"]
[6,"Debris / Blockages (Worksheet 3-6)",null,"D1, D2, D3",null,"D4, D7",null,"D5, D8",null,"D6, D9, D10"]
[null,null,null,null,"(1)",null,"(2)",null,"(3)",null,"(4)"]
[null,null,null,null,null,null,null,null,null,"Total Points",null,{"$f":"IF(OR(L7=\"\",L9=\"\",L11=\"\",L13=\"\",L15=\"\",L17=\"\"),\"\",SUM(L7:L18))","v":""}]
[null,null,null,"Vertical Stability Category Point Range for Excess Deposition and Aggradation"]
["Vertical Stability for Excess Deposition / Aggradation (use total points and check ü stability rating)",null,null,"No Deposition",null,"Moderate Deposition",null,"Excess Deposition",null,"Aggradation"]
[null,null,null,"< 15",null,"15 – 20",null,"21 – 30",null,"> 30 "]

{"sheet":"WS 3-18","index":26,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,11],[0,13,2,16],[1,2,1,6],[1,7,1,8],[1,9,1,11],[2,0,2,1],[2,9,2,11],[2,2,2,5],[2,6,2,8],[3,0,3,1],[3,7,3,8],[3,9,3,11],[4,0,5,2],[4,3,4,10],[4,11,5,11],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[3,2,3,5],[5,12,5,17],[6,0,7,0],[6,1,7,2],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,7,11],[8,11,9,11],[10,0,11,0],[10,1,11,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,11,11],[8,0,9,0],[8,1,9,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[12,11,13,11],[14,0,15,0],[14,1,15,2],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,15,11],[12,0,13,0],[12,1,13,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[19,7,19,8],[19,9,19,10],[16,0,17,2],[16,9,16,10],[17,3,17,10],[18,0,19,2],[18,3,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[19,3,19,4],[19,5,19,6]]}
["Vertical Stability Prediction for Channel Incision and Degradation",null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,"Landscape Type:",null,null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,"Date:",null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
["Vertical Stability Criteria (choose one stability category for each criterion 1–5)",null,null,"Vertical Stability Categories for Channel Incision / Degradation",null,null,null,null,null,null,null,"Selected Points               (from each row)"]
[null,null,null,"Not Incised",null,"Slightly Incised",null,"Moderately Incised",null,"Degradation"]
[1,"Sediment Competence (Worksheet 3-14)",null,"Does not indicate excess competence",null,"Trend to move larger sizes than D100 of bar or D84 of bed",null,"D100 of bed moved",null,"Particles much larger than D100 of bed moved"]
[null,null,null,null,"(2)",null,"(4)",null,"(6)",null,"(8)"]
[2,"Sediment Capacity (POWERSED)",null,"Does not indicate excess capacity",null,"Slight excess energy: up to 10% increase above reference",null,"Excess energy sufficient to increase load up to 50% of annual load",null,"Excess energy transporting more than 50% of annual load"]
[null,null,null,null,"(2)",null,"(4)",null,"(6)",null,"(8)"]
[3,"Degree of Channel Incision (BHR) (Worksheet 3-7)",null,"1.00 – 1.10",null,"1.11 – 1.30",null,"1.31 – 1.50",null,"> 1.50"]
[null,null,null,null,"(2)",null,"(4)",null,"(6)",null,"(8)"]
[4,"Stream Succession States (Worksheets 3-15 and 3-7)",null,"Does not indicate incision or degradation",null,"If BHR > 1.1 and stream type has W/d between 5–10",null,"If BHR > 1.1 and stream type has W/d less than 5",null,"(B→G), (C→G), (E→G), (D→G), (A→G), (E→A)"]
[null,null,null,null,"(2)",null,"(4)",null,"(6)",null,"(8)"]
[5,"Confinement               (MWR / MWRref) (Worksheet 3-9)",null,"0.80 – 1.00",null,"0.30 – 0.79",null,"0.10 – 0.29",null,"< 0.10"]
[null,null,null,null,"(1)",null,"(2)",null,"(3)",null,"(4)"]
[null,null,null,null,null,null,null,null,null,"Total Points",null,{"$f":"IF(OR(L7=\"\",L9=\"\",L11=\"\",L13=\"\",L15=\"\"),\"\",SUM(L7:L16))","v":""}]
[null,null,null,"Vertical Stability Category Point Range for Channel Incision and Degradation"]
["Vertical Stability for Channel Incision/ Degradation (use total points and check ü stability rating)",null,null,"Not Incised",null,"Slightly Incised",null,"Moderately Incised",null,"Degradation"]
[null,null,null,"< 12",null,"12 – 18",null,"19 – 27",null,"> 27 "]

{"sheet":"WS 3-19","index":27,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,11],[0,13,2,16],[1,2,1,6],[1,7,1,8],[1,9,1,11],[2,0,2,1],[2,9,2,11],[2,2,2,5],[2,6,2,8],[3,0,3,1],[3,7,3,8],[3,9,3,11],[4,0,5,2],[4,3,4,10],[4,11,5,11],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[3,2,3,5],[6,9,6,10],[6,11,7,11],[8,0,9,0],[8,1,9,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[8,11,9,11],[6,0,7,0],[6,1,7,2],[6,3,6,4],[6,5,6,6],[6,7,6,8],[10,11,11,11],[12,0,13,0],[12,1,13,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,13,11],[10,0,11,0],[10,1,11,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[17,7,17,8],[17,9,17,10],[14,0,15,2],[14,9,14,10],[15,3,15,10],[16,0,17,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[17,3,17,4],[17,5,17,6]]}
["Channel Enlargement Prediction",null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,"Landscape Type:",null,null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,"Date:",null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
["Channel Enlargement Prediction Criteria (choose one stability category for each criterion 1–4)",null,null,"Channel Enlargement Prediction Categories",null,null,null,null,null,null,null,"Selected Points (from each row)"]
[null,null,null,"No Increase",null,"Slight Increase",null,"Moderate Increase",null,"Extensive"]
[1,"Stream Succession Stage Shifts (Worksheet 3-15)",null,"Stream Type at Potential, (C→E), (Fb→B), (G→B), (F→Bc), (F→C), (D→C)",null,"(B→High W/d B), (C→High W/d C), (E→C)",null,"(G→F), (F→D)",null,"(C→D), (A→G), (B→G), (D→G), (C→G), (E→G), (E→A), (C→F)"]
[null,null,null,null,"(2)",null,"(4)",null,"(6)",null,"(8)"]
[2,"Lateral Stability (Worksheet 3-16)",null,"Stable",null,"Moderately Unstable",null,"Unstable",null,"Highly Unstable"]
[null,null,null,null,"(2)",null,"(4)",null,"(6)",null,"(8)"]
[3,"Vertical Stability Excess Deposition and Aggradation (Worksheet 3-17)",null,"No Deposition",null,"Moderate Deposition",null,"Excess Deposition",null,"Aggradation"]
[null,null,null,null,"(2)",null,"(4)",null,"(6)",null,"(8)"]
[4,"Vertical Stability Channel Incision and Degradation (Worksheet 3-18)",null,"Not Incised",null,"Slightly Incised",null,"Moderately Incised",null,"Degradation"]
[null,null,null,null,"(2)",null,"(4)",null,"(6)",null,"(8)"]
[null,null,null,null,null,null,null,null,null,"Total Points",null,{"$f":"IF(OR(L7=\"\",L9=\"\",L11=\"\",L13=\"\"),\"\",SUM(L7:L14))","v":""}]
[null,null,null,"Category Point Range"]
["Channel Enlargement Prediction (use total points and check ü stability rating)",null,null,"No Increase",null,"Slight Increase",null,"Moderate Increase",null,"Extensive"]
[null,null,null,"< 11",null,"11 – 16",null,"17 – 24",null,"> 24 "]

{"sheet":"WS 3-20","index":28,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,2,3,4],[0,0,0,6],[0,8,2,11],[1,2,1,4],[2,0,2,1],[2,4,2,5],[2,2,2,3],[4,0,5,2],[4,3,5,4],[4,5,5,5],[4,6,5,6],[6,0,9,0],[6,1,9,2],[6,3,6,4],[6,6,9,6],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,0,13,0],[10,1,13,2],[10,3,10,4],[10,6,13,6],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,0,17,0],[14,1,17,2],[14,3,14,4],[14,6,17,6],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,0,21,0],[18,1,21,2],[18,3,18,4],[18,6,21,6],[19,3,19,4],[20,3,20,4],[21,3,21,4],[26,0,27,2],[27,3,27,6],[28,0,29,2],[22,0,25,0],[22,1,25,2],[22,3,22,4],[22,6,25,6],[23,3,23,4],[24,3,24,4],[25,3,25,4]]}
["Overall Sediment Supply Prediction",null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,"Stream Type:",{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
["Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
["Overall Sediment Supply Prediction Criteria (choose corresponding points for each criterion 1–5)",null,null,"Stability Rating",null,"Points","Selected Points"]
[]
[1,"Lateral Stability (Worksheet 3-16)",null,"Stable",null,"1"]
[null,null,null,"Mod. Unstable",null,"2"]
[null,null,null,"Unstable",null,"3"]
[null,null,null,"Highly Unstable",null,"4"]
[2,"Vertical Stability Excess Deposition or Aggradation (Worksheet 3-17)",null,"No Deposition",null,"1"]
[null,null,null,"Mod. Deposition",null,"2"]
[null,null,null,"Excess Deposition",null,"3"]
[null,null,null,"Aggradation",null,"4"]
[3,"Vertical Stability Channel Incision or Degradation (Worksheet 3-18)",null,"Not Incised",null,"1"]
[null,null,null,"Slightly Incised",null,"2"]
[null,null,null,"Mod. Incised",null,"3"]
[null,null,null,"Degradation",null,"4"]
[4,"Channel Enlargement Prediction (Worksheet 3-19)",null,"No Increase",null,"1"]
[null,null,null,"Slight Increase",null,"2"]
[null,null,null,"Mod. Increase",null,"3"]
[null,null,null,"Extensive",null,"4"]
[5,"Pfankuch Channel Stability (Worksheet 3-10)",null,"Good:  Stable",null,"1"]
[null,null,null,"Fair:  Mod. Unstable",null,"2"]
[]
[null,null,null,"Poor:  Unstable",null,"4"]
[null,null,null,null,null,"Total Points",{"$f":"IF(OR(G7=\"\",G11=\"\",G15=\"\",G19=\"\",G23=\"\"),\"\",SUM(G7:G26))","v":""}]
[null,null,null,"Category Point Range"]
["Overall Sediment Supply Rating (use total points and check ü stability rating)",null,null,"Low","Moderate","High","Very High"]
[null,null,null,"< 6","6 – 10","11 – 15","> 15"]

{"sheet":"WS 3-21","index":29,"n_rows":33,"n_cols":41,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,30,4,34],[3,35,4,38],[1,40,5,43],[3,0,4,0],[3,1,4,5],[3,6,4,7],[3,8,4,11],[3,12,4,14],[3,15,4,19],[3,20,4,21],[3,22,4,26],[3,27,4,29],[5,0,6,0],[5,1,6,3],[5,4,6,6],[5,7,5,10],[5,11,6,13],[5,14,5,17],[5,18,6,20],[5,21,5,24],[5,25,6,27],[5,28,5,31],[5,32,6,34],[5,35,6,38],[0,0,0,38],[1,1,1,18],[1,19,1,21],[1,22,1,38],[2,1,2,11],[2,12,2,13],[2,14,2,18],[2,19,2,23],[2,24,2,27],[2,34,2,37],[6,7,6,10],[6,14,6,17],[6,21,6,24],[6,28,6,31],[7,25,8,31],[7,32,8,35],[7,36,8,38],[9,0,12,0],[10,1,12,4],[10,5,10,7],[10,8,10,10],[10,11,12,15],[10,16,10,18],[10,19,10,21],[7,0,8,0],[7,1,8,8],[7,9,8,11],[7,12,8,16],[7,17,8,20],[7,21,8,24],[11,33,12,35],[11,36,12,38],[13,5,13,13],[13,14,13,22],[13,23,13,38],[14,5,14,13],[14,14,14,22],[14,23,14,38],[10,22,12,24],[10,25,10,26],[10,27,10,38],[11,5,12,7],[11,8,12,10],[11,16,12,18],[11,19,12,21],[11,25,12,26],[11,27,12,29],[11,30,12,32],[17,17,18,21],[17,22,18,32],[17,33,18,38],[15,1,16,3],[15,4,16,5],[15,6,16,9],[15,10,16,13],[15,14,16,17],[15,18,16,21],[15,22,16,25],[15,26,16,29],[15,30,16,34],[15,35,16,38],[17,1,18,7],[17,8,18,10],[22,12,22,14],[22,15,22,17],[22,18,22,20],[22,21,22,26],[23,9,23,15],[19,28,20,32],[19,33,20,38],[21,0,22,0],[21,1,22,6],[21,7,22,8],[21,9,21,20],[21,21,21,26],[21,27,22,29],[21,30,22,38],[22,9,22,11],[19,1,20,6],[19,7,20,8],[19,9,20,13],[19,14,20,18],[19,19,20,25],[19,26,20,27],[13,0,20,0],[13,1,14,4],[17,11,18,16],[24,24,25,26],[24,27,25,28],[24,29,25,31],[24,32,25,33],[24,34,25,36],[24,37,25,38],[23,27,23,38],[24,0,25,0],[24,1,25,7],[24,8,25,10],[24,11,25,12],[24,13,25,14],[24,15,25,16],[24,17,25,18],[24,19,25,21],[24,22,25,23],[23,1,23,8],[26,21,27,22],[26,23,27,28],[26,29,27,30],[26,31,27,36],[26,37,27,38],[28,26,28,28],[28,29,28,38],[26,0,27,0],[26,1,27,2],[26,5,27,6],[26,9,27,10],[26,13,27,14],[26,17,27,18],[32,23,33,38],[32,0,33,0],[32,2,33,5],[32,7,33,12],[32,13,33,15],[32,16,33,19],[32,20,33,22],[29,26,29,28],[29,29,29,38],[30,26,30,28],[30,29,30,38],[31,26,31,28],[31,29,31,38]]}
["Summary of Stability Conditions"]
["Stream:                                                                               ",{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location:",null,null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Observers:",{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,null,null,null,null,null,null,"Date:",null,{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""},null,null,null,null,"Stream Type:",null,null,null,null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""},null,null,null,"Landscape Type:",null,null,null,null,null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Channel Dimension","Bankfull Mean Depth (ft):",null,null,null,null,null,null,"Bankfull Width (ft):",null,null,null,null,null,null,"Cross-Sectional Area (ft2):",null,null,null,null,null,null,"Width/Depth Ratio:",null,null,null,null,null,null,null,"Entrenchment Ratio:"]
[]
["Channel Pattern","Mean: Range:",null,null,"l/Wbkf:",null,null,null,null,null,null,"Lm/Wbkf:",null,null,null,null,null,null,"Rc/Wbkf:",null,null,null,null,null,null,"MWR:",null,null,null,null,null,null,"Sinuosity:"]
[]
["Streamflow","Bankfull Mean       Velocity (ūbkf) (ft/sec):",null,null,null,null,null,null,null,null,null,null,"Bankfull   Discharge (Qbkf):",null,null,null,null,null,null,null,null,"Estimation Method:",null,null,null,null,null,null,null,null,null,null,"Drainage Area (mi2):"]
[]
["River Profile & Bed Features","Check:",null,null,"Riffle/Pool",null,null,null,null,null,"Step/Pool",null,null,null,"Plane Bed",null,null,null,null,"Convergence/Divergence",null,null,null,null,null,null,null,null,"Dunes/Antidunes/Smooth Bed"]
[null,"Bankfull Max Depth (ft):",null,null,null,"Riffle",null,null,"Pool",null,null,"Depth Ratio (max to mean):",null,null,null,null,"Riffle",null,null,"Pool",null,null,"Pool-to-Pool Spacing:",null,null,"Ratio",null,"Slope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valley:",null,null,null,null,null,"Water Surface:"]
[]
["Level III Stream Stability Indices","Riparian Vegetation",null,null,null,"Current Composition/Density:",null,null,null,null,null,null,null,null,"Potential Composition/Density:",null,null,null,null,null,null,null,null,"Remarks:  Condition, Vigor & Usage of Existing Reach:"]
[]
[null,"Flow Regime:",null,null,null,null,"Stream Size & Order: ",null,null,null,null,null,null,null,"Meander Patterns:",null,null,null,null,null,null,null,"Depositional Patterns:",null,null,null,null,null,null,null,"Debris/Channel Blockages:"]
[]
[null,"Degree of Incision (Bank-Height Ratio):",null,null,null,null,null,null,null,null,null,"Degree of Incision Stability Rating:",null,null,null,null,null,null,null,null,null,null,"Modified Pfankuch Stability Rating (Numeric & Adjective Rating):"]
[]
[null,"W/d Ratio State (W/d) / (W/dref):",null,null,null,null,null,null,null,"W/d Ratio State Stability Rating:",null,null,null,null,null,null,null,null,null,"Degree of Confinement (MWR / MWRref):",null,null,null,null,null,null,null,null,"MWR / MWRref Stability Rating:"]
[]
["Bank Erosion Summary","Length of Reach Studied (ft):",null,null,null,null,null,null,null,"Annual Streambank Erosion Rate:",null,null,null,null,null,null,null,null,null,null,null,"Curve Used:",null,null,null,null,null,"Remarks:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(tons/yr)",null,null,null,null,null,"(tons/yr/ft)"]
["Sediment Capacity (POWERSED)","  Sufficient Capacity",null,null,null,null,null,null,null,"Insufficient Capacity",null,null,null,null,null,null,null,"Excess Capacity ",null,null,null,null,null,null,"Remarks:"]
["Entrainment/ Competence","Largest Particle from Bar Sample (mm):",null,null,null,null,null,null,null,null,null,"t =",null,null,null,"t =",null,null,null,"Existing Depth:",null,null,null,null,"Required Depth:",null,null,null,null,"Existing Slope:",null,null,null,null,"Required Slope:"]
[]
["Stream Succession",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing Stream State (Type):",null,null,null,null,null,null,null,"Potential Stream State (Type):"]
[]
["Lateral Stability",null,"Stable",null,null,null,null,null,"Mod. Unstable",null,null,null,null,null,"Unstable",null,null,null,null,null,"Highly Unstable",null,null,null,null,null,"Remarks:"]
["Vertical Stability (Aggradation)",null,"No Deposition",null,null,null,null,null,"Mod. Deposition",null,null,null,null,null,"Ex. Deposition",null,null,null,null,null,"Aggradation",null,null,null,null,null,"Remarks:"]
["Vertical Stability (Degradation)",null,"Not Incised",null,null,null,null,null,"Slightly Incised",null,null,null,null,null,"Mod. Incised",null,null,null,null,null,"Degradation",null,null,null,null,null,"Remarks:"]
["Channel Enlargement",null,"No Increase",null,null,null,null,null,"Slight Increase",null,null,null,null,null,"Mod. Increase",null,null,null,null,null,"Extensive",null,null,null,null,null,"Remarks:"]
["Sediment Supply (Channel Source)",null,"Low",null,null,null,null,"Moderate",null,null,null,null,null,"High",null,null,"Very High",null,null,null,"Remarks:"]

{"sheet":"Level IV","index":30,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,2,2]]}
[null,"Level IV: Monitoring & Validation","River Stability Field Guide Page Number"]
[null,"Forms & Worksheets"]
[]
[]
["1.","Worksheet 4-1.  Summary of annual data comparisons and time-trend change.","Page 4-8"]
["2.","Worksheet 4-2.  Bank profile and bank erosion summary data form.","Page 4-11"]
["3.","Worksheet 4-3.  Streambank erosion validation.","Page 4-15"]
["4.","Worksheet 4-4.  Field form to document scour chain results and corresponding bed-elevation changes.","Page 4-21"]
["5.","Worksheet 4-5.  Dimensionless shear stress validation.","Page 4-25"]
["6.","Worksheet 4-6.  Dimensional shear stress validation.","Page 4-27"]
["7.","Worksheet 4-7.  Procedure to validate hydraulic relations using gage station data.","Page 4-29"]
["8.","Worksheet 4-8.  Channel enlargement comparison of predicted vs. measured values.","Page 4-36"]

{"sheet":"WS 4-1","index":31,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,32,0],[0,1,0,10],[0,11,32,11],[1,1,1,2],[5,1,7,3],[5,4,5,5],[5,9,5,10],[6,4,6,5],[6,6,6,8],[6,9,6,10],[7,6,7,7],[5,6,5,8],[12,6,12,7],[4,1,4,10],[8,1,12,1],[8,2,8,3],[1,17,1,18],[3,1,3,2],[3,4,3,5],[3,6,3,7],[3,8,3,9],[2,1,2,2],[2,8,2,9],[1,13,4,16],[1,8,1,9],[1,3,1,7],[2,3,2,7],[8,6,8,7],[9,2,9,3],[9,6,9,7],[10,2,10,3],[10,6,10,7],[11,2,11,3],[11,6,11,7],[14,2,14,3],[14,6,14,7],[15,2,15,3],[15,6,15,7],[13,2,13,3],[13,6,13,7],[16,2,16,3],[16,6,16,7],[12,2,12,3],[17,1,17,10],[18,1,22,1],[18,2,18,3],[18,6,18,8],[19,2,19,3],[19,6,19,8],[20,2,20,3],[20,6,20,8],[21,2,21,3],[21,6,21,8],[22,2,22,3],[22,6,22,8],[13,1,16,1],[24,1,24,3],[25,1,25,3],[25,6,28,6],[25,7,25,8],[26,1,26,3],[26,7,26,8],[27,1,27,3],[27,7,27,8],[32,2,32,3],[32,7,32,8],[33,1,33,10],[28,1,28,3],[28,7,28,8],[29,1,32,1],[29,2,29,3],[29,6,32,6],[29,7,29,8],[30,2,30,3],[30,7,30,8],[31,2,31,3],[31,7,31,8]]}
[null,"Data Comparison Form"]
[null,"Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,"StreamType:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""},null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[null,"Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
[null,"Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},"Date of Survey 1:",null,null,null,"Date of Survey 2:"]
[]
[null,null,null,null,"Riffle XS:",null,"Pool XS:",null,null,"Glide XS:"]
[]
[null,null,null,null,"Survey 1","Survey 2","Survey 1",null,"Survey 2","Survey 1","Survey 2"]
[null,"Cross-section Dimensions","Width (Wbkf)"]
[null,null,"Mean Depth (dbkf)"]
[null,null,"Width/Depth Ratio (W/d)"]
[null,null,"Cross-Sectional Area (Abkf)"]
[null,null,"Bankfull Max Depth (dmax)"]
[null,"Pebble Count","D35 (mm)"]
[null,null,"D50 (mm)"]
[null,null,"D84 (mm)"]
[null,null,"D100 (mm)"]
[]
[null,"Pattern",null,null,"Survey 1","Survey 2",null,null,null,"Survey 1","Survey 2"]
[null,null,"Linear Wavelength to Bankfull Width (l / Wbkf)",null,null,null,"Arc Length to Riffle Width (La / Wbkf)"]
[null,null,"Stream Meander Length Ratio (Lm / Wbkf)",null,null,null,"Riffle Length to Riffle Width (Lr / Wbkf)"]
[null,null,"Radius of Curvature to Riffle Width (Rc / Wbkf)",null,null,null,"Pool-to-Pool Spacing to Riffle Width (Ps / Wbkf)"]
[null,null,"Meander Width Ratio    (Wblt / Wbkf)",null,null,null,"Pool Length to Riffle Width (Lp / Wbkf)"]
[]
[null,null,null,null,"Survey 1","Survey 2",null,null,null,"Survey 1","Survey 2"]
[null,"Revised Pfankuch Channel Stability Rating",null,null,null,null,"Bar Sample ","D35 (mm)"]
[null,"Bank-Height Ratio",null,null,null,null,null,"D50 (mm)"]
[null,"Point Bar Slope (Spb)",null,null,null,null,null,"D84 (mm)"]
[null,"Sinuosity (k)",null,null,null,null,null,"D100 (mm)"]
[null,"Dimensionless Slope Ratios","Riffle Slope Ratio (Srif/S)",null,null,null,"Dimensionless Max Depth Ratios","Max Riffle Depth Ratio (dmax/dbkf)"]
[null,null,"Run Slope Ratio (Srun/S)",null,null,null,null,"Max Run Depth Ratio (dmaxr/dbkf)"]
[null,null,"Pool Slope Ratio (Sp/S)",null,null,null,null,"Max Pool Depth Ratio (dmaxp/dbkf)"]
[null,null,"Glide Slope Ratio (Sg/S)",null,null,null,null,"Max Glide Depth Ratio (dmaxg/dbkf)"]

{"sheet":"WS 4-2","index":32,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[29,2,29,3],[29,7,29,8],[26,2,26,3],[26,7,26,8],[27,2,27,3],[27,7,27,8],[28,2,28,3],[28,7,28,8],[23,2,23,3],[23,7,23,8],[24,2,24,3],[24,7,24,8],[25,2,25,3],[25,7,25,8],[20,2,20,3],[20,7,20,8],[21,2,21,3],[21,7,21,8],[22,2,22,3],[22,7,22,8],[17,2,17,3],[17,7,17,8],[18,2,18,3],[18,7,18,8],[19,2,19,3],[19,7,19,8],[14,2,14,3],[14,7,14,8],[15,2,15,3],[15,7,15,8],[16,2,16,3],[16,7,16,8],[10,1,10,3],[10,6,10,8],[12,2,12,3],[12,7,12,8],[13,2,13,3],[13,7,13,8],[7,2,7,4],[7,7,7,8],[8,0,8,1],[8,2,8,4],[8,5,8,6],[8,7,8,8],[5,0,5,1],[5,2,5,4],[5,5,5,6],[5,7,5,8],[6,1,6,4],[6,7,6,8],[0,0,1,8],[0,10,4,13],[2,1,2,4],[2,6,2,8],[3,1,3,4],[3,6,3,8],[4,0,4,1],[4,2,4,4],[4,5,4,6],[4,7,4,8]]}
["Bank Profile Form",null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[]
["Stream:",{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,"Observers:",{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""}]
["Location:",{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
["Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""},null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
["Cross-Section:",null,null,null,null,"BEHI Adjective Rating:"]
["Bank:",null,null,null,null,"NBS Adjective Rating:"]
["Toe-Pin Station (ft):",null,null,null,null,"Predicted Erosion (ft):"]
["Toe-Pin Elevation (ft):",null,null,null,null,"Measured Erosion (ft):"]
[]
["Date:",null,null,null,null,"Date:"]
["Horizontal","Vertical","Notes",null,null,"Horizontal","Vertical","Notes"]
[0,0,null,null,null,0,0]

{"sheet":"WS 4-3","index":33,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,23,0],[0,1,0,9],[0,10,23,10],[1,1,1,3],[1,4,1,6],[7,1,10,1],[7,2,10,2],[7,3,7,5],[7,7,7,8],[8,3,8,5],[8,7,8,8],[9,3,10,5],[9,6,10,6],[9,7,10,8],[9,9,10,9],[11,3,11,9],[1,16,1,17],[3,1,3,3],[3,4,3,7],[4,3,4,9],[5,3,6,6],[5,7,5,9],[6,7,6,9],[2,1,2,3],[1,12,3,15],[1,7,1,8],[2,4,2,6],[2,7,2,8],[12,3,12,5],[12,7,12,8],[13,3,13,5],[13,7,13,8],[14,3,15,5],[14,6,15,6],[14,7,15,8],[14,9,15,9],[21,3,21,9],[22,1,22,9],[16,3,16,9],[17,1,20,1],[17,2,20,2],[17,3,17,5],[17,7,17,8],[18,3,18,5],[18,7,18,8],[19,3,20,5],[19,6,20,6],[19,7,20,8],[19,9,20,9],[12,1,15,1],[12,2,15,2]]}
[null,"Streambank Erosion Validation"]
[null,"Stream:",null,null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""},null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[null,"Location:",null,null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
[null,"Observers:",null,null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[]
[null,null,null,"Prediction                         ",null,null,null,"Actual Values   "]
[null,null,null,null,null,null,null,"(Observed Values)"]
[null,"Riffle XS:",null,"BEHI Rating",null,null,null,"BEHI Rating"]
[null,null,null,"NBS Rating",null,null,null,"NBS Rating"]
[null,null,null,"Predicted Erosion (ft/yr) using Appropriate Curve (e.g., Colorado or Yellowstone Curve)",null,null,null,"Measured Erosion from Bank Pins and Bank Profile (ft/yr)"]
[]
[]
[null,"Glide XS:",null,"BEHI Rating",null,null,null,"BEHI Rating"]
[null,null,null,"NBS Rating",null,null,null,"NBS Rating"]
[null,null,null,"Predicted Erosion (ft/yr) using Appropriate Curve (e.g., Colorado or Yellowstone Curve)",null,null,null,"Measured Erosion from Bank Pins and Bank Profile (ft/yr)"]
[]
[]
[null,"Pool XS:",null,"BEHI Rating",null,null,null,"BEHI Rating"]
[null,null,null,"NBS Rating",null,null,null,"NBS Rating"]
[null,null,null,"Predicted Erosion (ft/yr) using Appropriate Curve (e.g., Colorado or Yellowstone Curve)",null,null,null,"Measured Erosion from Bank Pins and Bank Profile (ft/yr)"]
[]
[]
[null,"Plot Measured Erosion Values According to their Respective BEHI and NBS Ratings on Appropriate Curve; e.g., Colorado Curve (Figure 4-8) or Yellowstone Curve (Figure 4-9)"]

{"sheet":"WS 4-4","index":34,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,1],[1,2,1,6],[1,8,1,11],[1,13,5,16],[2,0,2,1],[2,2,2,3],[2,4,2,5],[2,7,2,8],[12,10,12,11],[15,0,15,1],[6,0,7,0],[8,0,9,0],[12,0,12,1],[12,2,12,4],[12,5,12,7],[12,8,12,9]]}
["Scour Chain Installation and Recovery Data"]
["Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,"Location:",{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
["Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""},"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""},"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[null,null,"Installation Data (Survey 1)",null,null,null,"Recovery Data (Survey 2)"]
[null,null,"From Cross-Section",null,"Particles Near Chain",null,"Chain Recovery",null,null,null,"Particles Near Chain"]
[null,null,"Station   (ft)","Elevation (ft)","Largest (mm)","2nd Largest (mm)","Scenario # (1–5)","Scour deptha (ft)","Elevationb (ft)","Net changec (ft)","Largest (mm)","2nd Largest (mm)"]
["Riffle","Chain #1"]
[null,"Chain #2"]
["Glide","Chain #3"]
[null,"Chain #4"]
[]
["Scenario #1",null," Scenario #2",null,null," Scenario #3 ",null,null," Scenario #4",null," Scenario #5"]
["No Net Change",null,"Net Loss: Degradation",null,null,"No Net Change: Stable, Dynamic",null,null,"Net Gain: Aggradation",null,"(Oops)"]
[]
[]
["Base-level"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["a Scenario 2 or 3.  Scenario 2:  Enter length of chain exposed.  Scenario 3:  Enter length of chain exposed then subsequently buried."]
["b Scenario 3 or 4.  Scenario 3:  Enter elevation of bed at same station at 2nd year.  Scenario 4:  Enter depth of material over chain."]
["c Scenario 3:  Subtract 1st and 2nd year elevations to calculate net change in bed."]

{"sheet":"WS 4-5","index":35,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,22,0],[0,1,0,8],[0,9,22,9],[0,11,4,14],[1,1,1,2],[6,1,6,5],[6,6,6,8],[7,1,7,4],[7,6,7,7],[8,1,8,4],[8,6,8,7],[9,1,9,4],[9,5,10,5],[9,6,10,7],[13,1,13,8],[14,1,14,8],[1,15,1,16],[3,1,3,2],[3,3,3,6],[4,1,4,8],[5,1,5,5],[5,6,5,8],[2,1,2,2],[2,3,2,6],[1,3,1,6],[15,1,15,4],[15,6,15,7],[9,8,10,8],[10,1,10,4],[11,1,11,4],[11,5,12,5],[11,6,12,7],[11,8,12,8],[12,1,12,4]]}
[null,"Competence Form to Validate Dimensionless Shear Stress (t*)",null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[null,"Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,"Stream Type:",{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
[null,"Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,"Landscape Type:",{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
[null,"Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[]
[null,"Prediction                         ",null,null,null,null,"Actual Values   "]
[null,"(Values from Worksheet 3-14)",null,null,null,null,"(Observed Values)"]
[null,"Predicted Required Depth d (ft):",null,null,null,null,"Measured Depth d (ft):"]
[null,"Predicted Required Slope S (ft):",null,null,null,null,"Measured Slope S (ft):"]
[null,"Predicted t* ",null,null,null,null,"Dmax from Scour Chain or Bedload Sampler (ft):"]
[null,"Eq. 1:  t* = 0.0834 (                ) –0.872"]
[null,"Predicted t* ",null,null,null,null,"Actual  t*"]
[null,"Eq. 2:  t* = 0.0384 (Dmax/D50) –0.887  "]
[]
[null,"Plot Actual t* and Survey 1 Relative Protrusion of Bed Surface                   (Bar Dmax/Riffle D50) on Andrews Relation (1983)"]
[null,"Bar Sample D100 (mm)",null,null,null,null,"Riffle Bed Material D50 (mm)"]

{"sheet":"WS 4-6","index":36,"n_rows":19,"n_cols":19,"rows_kept":19,"cut":false,"hidden":false,"merged":[[7,1,7,6],[7,7,7,9],[0,0,1,10],[0,18,2,21],[2,1,2,2],[2,12,2,13],[4,1,4,2],[5,1,5,9],[6,1,6,6],[6,7,6,9],[3,1,3,2],[2,3,2,7],[3,3,3,7],[4,3,4,7],[17,1,17,9],[18,1,18,9],[12,1,13,4],[12,7,13,8],[12,9,13,9],[14,2,15,4],[14,7,15,8],[14,9,15,9],[8,7,9,8],[8,9,9,9],[10,1,11,4],[10,7,11,8],[16,1,16,9],[10,9,11,9],[8,1,9,4]]}
["Competence Form to Validate Dimensional Shear Stress (t)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[]
[null,"Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""},null,null,null,null,"Stream Type:",{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
[null,"Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,"Landscape Type:",{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
[null,"Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,"Date:",{"$f":"IF('Cover Sheet'!J12=\"\",\"\",'Cover Sheet'!J12)","v":""}]
[]
[null,"Prediction                         ",null,null,null,null,null,"Actual Values   "]
[null,"(Values from Worksheet 3-14)",null,null,null,null,null,"(Observed Values)"]
[null,"Predicted largest moveable particle size at bankfull shear stress (mm)",null,null,null,"Shields","CO","Measured largest size particle Dmax (mm) from scour chain or bedload measurement"]
[]
[null,"Predicted Depth d (ft)",null,null,null,"Shields","CO","Measured Depth d (ft):"]
[]
[null,"Predicted Slope S (ft)",null,null,null,"Shields","CO","Measured Slope S (ft):"]
[]
[null,null,"Predicted shear stress required to initiate movement of measured Dmax (mm)",null,null,"Shields","CO","Bankfull shear stress    t = gdS      (g = 62.4)"]
[]
[]
[null,"Plot Bankfull Shear Stress t on Shields/Colorado Relation "]
[null,"Using Largest particle measured (Dmax) and the Corresponding Bankfull Shear Stress (t)"]

{"sheet":"WS 4-7","index":37,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[[40,18,41,26],[41,27,42,37],[19,27,19,37],[0,18,3,21],[4,2,4,15],[0,2,0,15],[1,2,1,15],[2,2,2,15],[3,2,3,15],[17,1,17,3],[17,4,17,11],[17,12,17,13],[17,14,17,15],[5,2,5,15],[6,2,6,15],[7,2,7,15],[8,2,8,15],[9,2,9,15],[10,2,10,15],[11,2,11,15],[12,2,12,15],[20,1,20,2],[21,1,21,2],[13,2,13,15],[14,2,14,15],[15,2,15,15],[18,1,18,2],[19,1,19,2],[19,9,19,10]]}
[null,null,"Validation of Hydraulic Relationships using Gage Station Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[null,"1.","Obtain the drainage area associated with the gaging station."]
[null,"2.","Obtain the field-determined bankfull discharge at the gaging station(s) (Figure 2-3)."]
[null,"3.","Obtain the bankfull channel dimensions from the gaging station hydraulic geometry relationships (discharge vs. width, depth, area, and velocity)"]
[null,"4.","Measure the average water surface slope."]
[null,"5.","Perform an active bed pebble count on the riffle to obtain D84."]
[null,"6.","Determine the stream type."]
[null,"7.","Solve for Manning’s 'n' at the bankfull stage:  n = (1.49 R2/3 S1/2) / ū (use the bankfull mean velocity from Step 3)."]
[null,"8.","Calculate relative roughness:  R/D84.  Make sure that D84 is converted from millimeters to feet.  Hydraulic radius (R) and mean depth (dbkf) are often used interchangeably when width/depth ratios are greater than 12.0."]
[null,"9.","Calculate shear velocity:  u* = (gRS)1/2."]
[null,"10.","Calculate friction factor:  ū/u*. "]
[null,"11.","Plot bankfull discharge as a function of drainage area on the appropriate regional curve."]
[null,"12.","Plot bankfull channel dimensions as a function of drainage area on the appropriate regional curve (note stream type of plotted values using unique symbols)."]
[null,"13.","Plot relative roughness by friction factor (Figure 2-29) (Example in Figure 4-10)."]
[null,"14.","Plot Manning’s 'n' by friction factor (Figure 2-30) (Example in Figure 4-11)."]
[null,"15.","Plot Manning’s 'n' by stream type (Figure 2-31) (Example in Figure 4-12)."]
[]
[null,"Gage Station Name:",null,null,null,null,null,null,null,null,null,null,"Gage Station #:"]
[null,1,null,2,"3a","3b","3c","3d",4,"5a","5b",6,7,8,9,10]
[null,"Drainage Area",null,"Bankfull Discharge","Bankfull Width","Bankfull Mean Depth","Bankfull Area","Bankfull Velocity","Ave. Water Surface Slope","D84",null,"Stream Type ","Manning's 'n'","Relative Roughness","Shear Velocity","Friction Factor"]
[null,"(mi2)",null,"Qbkf (cfs)","Wbkf (ft)","dbkf (ft)","Abkf (ft2)","ūbkf (ft/s)","S (ft/ft)","(mm)","(ft)",null,null,"R/D84 (ft/ft)","u* (ft/sec)","ū/u*"]

{"sheet":"WS 4-8","index":38,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,11,0],[0,1,0,12],[0,13,11,13],[0,15,1,18],[1,1,1,2],[6,1,6,3],[6,5,6,8],[9,1,9,3],[10,1,10,3],[11,1,11,3],[2,9,2,10],[3,9,3,10],[1,3,1,12],[1,19,1,20],[3,1,3,2],[4,1,4,12],[5,1,5,3],[5,5,5,8],[5,9,5,12],[2,1,2,2],[2,19,2,20],[2,11,2,12],[2,3,2,8],[3,3,3,8],[12,1,12,12],[6,9,6,12],[7,1,7,3],[7,5,7,12],[8,1,8,3],[8,5,8,6],[8,7,8,8],[8,9,8,10],[8,11,8,12]]}
[null,"Channel Enlargement Comparison of Predicted vs. Measured Values",null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  Cells with Text and Formulas are Locked; To Unlock Cells, Unprotect the Sheet within \"Permissions\" under the \"File\" Tab."]
[null,"Stream:",null,{"$f":"IF('Cover Sheet'!E10=\"\",\"\",'Cover Sheet'!E10)","v":""}]
[null,"Location:",null,{"$f":"IF('Cover Sheet'!E11=\"\",\"\",'Cover Sheet'!E11)","v":""},null,null,null,null,null,"Stream Type:",null,{"$f":"IF('Cover Sheet'!J10=\"\",\"\",'Cover Sheet'!J10)","v":""}]
[null,"Observers:",null,{"$f":"IF('Cover Sheet'!E12=\"\",\"\",'Cover Sheet'!E12)","v":""},null,null,null,null,null,"Landscape Type:",null,{"$f":"IF('Cover Sheet'!J11=\"\",\"\",'Cover Sheet'!J11)","v":""}]
[]
[null,"Survey 1 Date:",null,null,null,"Survey 2 Date:",null,null,null,"Feature & Location: "]
[]
[null,"Predicted Enlargement (Worksheet 3-19)",null,null,null,"Net Change from Cross-Section Resurvey (Worksheet 4-1)"]
[null,"No Increase",null,null,null,"Width",null,"Depth",null,"W/d Ratio",null,"Cross-Sectional Area"]
[null,"Slight Increase",null,null,"Surv. 1",null,"(ft)",null,"(ft)",null,"(ft/ft)",null,"(ft2)"]
[null,"Moderate Increase",null,null,"Surv. 2",null,"(ft)",null,"(ft)",null,"(ft/ft)",null,"(ft2)"]
[null,"Extensive",null,null,null,null,"% Change",null,"% Change",null,"% Change",null,"% Change"]